Thread: range name
View Single Post
  #1   Report Post  
Bob Phillips
 
Posts: n/a
Default

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.