View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mark Campbell Mark Campbell is offline
external usenet poster
 
Posts: 16
Default Name a dynamic Range

I am currently using the following formula to name a range of data in a list
whic is regularly updated.

=Offset(Sheet1!$A$1,0,0,counta(Sheet1!$A:$A),35)

I wish to create another range of data from the same sheet which contains 35
columns - I want the range to consist only of the rows in which column "U"
is blank.
I would also like the range to be dynamic so it updates as new rows are added.

thanks for your help.

Regards

Mark