Re: How to Define or Select a Dynamic Range with VBA

["Longworth, Damon" <dlongworth@LAKEREGIONAL.COM>]

This should help you find the needed range:

BegRange = _
    Cells.Find(What:="~*~*~*", After:=ActiveCell, LookIn:=xlFormulas, LookAt
_
        :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext,
MatchCase:= _
        False, SearchFormat:=False).Address
EndRange = Range("AH65536").End(xlUp).Address


Damon Longworth
Lake Regional Health System
54 Hospital Dr.
Osage Beach, MO 65065
Tel. 573-348-8373 - Fax 573-348-8167
<mailto:dlongworth@lakeregional.com>


-----Original Message-----
From: Jim . [mailto:Escojpoer@AOL.COM]
Sent: Thursday, July 24, 2003 3:49 PM
To: EXCEL-G@PEACH.EASE.LSOFT.COM
Subject: How to Define or Select a Dynamic Range with VBA


I am trying to define(or just select) a dynamic range to sort that will
always have a different number of rows, and will always start in a different
row,
but always the same amount of columns and will always be between a header
row
of ***********(asterisks)in Column R and the last occupied row in Column AH.
One time it might be R7:AH200, next time it might be R34:AH50, but always
between R and AH.
 Thanks
  Jim


--------------------------------------------------------------------------
The EXCEL-G list is hosted on a Windows NT(TM) machine running L-Soft
international's LISTSERV(R) software.  For subscription/signoff info
and archives, see http://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G


 This email originated from Lake Regional Health System. This email message,
including any attachments, contains confidential information which is
intended only for the use of the individual or entity named above.  If the
reader of this email is not the intended recipient or agent responsible for
delivering it to the intended recipient, he/she is hereby notified that you
are in possession of confidential and privileged information.  If you have
received this email in error, please notify the sender immediately. State
and federal law prohibits you from making further disclosure of this
information without specific written consent of the person to whom it
pertains, or as otherwise permitted by law.

--------------------------------------------------------------------------
The EXCEL-G list is hosted on a Windows NT(TM) machine running L-Soft
international's LISTSERV(R) software.  For subscription/signoff info
and archives, see http://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G