View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
CellShocked CellShocked is offline
external usenet poster
 
Posts: 277
Default How do I name a range and then have that range be dynamic?

I want to select the entire contents of a worksheet, but that data set
will change each time I open it as records will be added to it every day.

I want to always choose all records, and there will never be any
non-contiguous rows in the data or blank rows in it.

So I can make a direct call to it and always get all of it by way of
the named range.