Hello efi
Your name will refer to
=OFFSET(Sheet1!A1,,,COUNTA(Sheet1!A:A)-1)
HTH
Regards
Pascal

"efi" a écrit dans le message de
...
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/