Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sum a column within a name definition | Excel Discussion (Misc queries) | |||
f statistic, p value definition | Excel Worksheet Functions | |||
$ definition | Excel Worksheet Functions | |||
End of data definition | Excel Discussion (Misc queries) | |||
The definition of.... | Excel Worksheet Functions |