View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
efi[_5_] efi[_5_] is offline
external usenet poster
 
Posts: 1
Default question on the definition of refer to

Hi,
I want to define a name that will indlude all the data in a specific
column except the first cell.
How can I do it?

Currently in my definitioon is written : =Sheet1!$A:$A

I want it to be dynamically, meaning if the user will insert a new row
in this column it will be added to the definition, this is why I
defined the whole column.

Any ideas?

10x.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/