One way:

Dynamic range from A1 to the first empty cell in column A:

=A1:INDEX(A1:A100,MATCH(1,INDEX(--(A1:A100=""),,1),0)-1)


--
Biff
Microsoft Excel MVP


"Robert H" wrote in message
...
I need to creat a dynamic range that that expands as the range of data
grows but ignors a table of data that is a few lines below the active
table. using the countA function to check for empty cells works but
if I have the entire colum as the count range it checks for all non
empty cells which messes up the range. Im looking for something like
Selection.End(xlDown) in VBA that will go to the first empty cell so I
dont get into the next table of data.