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

["Jim ." <Escojpoer@AOL.COM>]

Thanks Damon. I can use this in a lot of places. Preciate it!!
 Jim

In a message dated 7/24/2003 5:18:28 PM Eastern Daylight Time,
dlongworth@LAKEREGIONAL.COM writes:

> 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