Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
create range bar graph | Charts and Charting in Excel | |||
Dynamic Print Range Help | Excel Worksheet Functions | |||
Define a range based on another named range | Excel Worksheet Functions | |||
named range refers to: in a chart | Excel Discussion (Misc queries) | |||
range names | Excel Worksheet Functions |