use a dynamic name, something like
=OFFSET($A$1,,,COUNTA($A:$A))
--
HTH
RP
(remove nothere from the email address if mailing direct)
"P.hamsa" wrote in message
...
I have defined a range name for a group of cells.
If I add new rows/columns, I want those cells to be included
in to the range name automatically.
Can you please let me know?
Thanks in advance.
|