Thread: Dynamic Range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] my.wandering.mind@gmail.com is offline
external usenet poster
 
Posts: 16
Default Dynamic Range

Hi All,

I have a data table which starts from A5001 to A50674. This data will
expand by adding new rows and columns.

How can I name this data.

Also I would like to create separate names for each column that is
added.
I tried using =OFFSET($A$5001,0,0,COUNTA($A:$A),1), but it does not
recognize the data.

Can someone help me.

Thanks
vishnu