Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need to create a macro that will create a range name - I'm OK to do that
but my issues is each month the range name's "range" changes. I have set it up so each month the original range name is deleted and a new one created that covers the additional rows of data. The starting cell (row/column) and the number of columns stays the same, it's just the number of rows that change. I know there are ways to count the number of rows but not sure how it set this up with the range name - any help would be appreciated. Thx. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
converting email address names in a range of cells to real names | Excel Worksheet Functions | |||
Reference Range Names in Macro | Excel Discussion (Misc queries) | |||
COPYING FORMULA CONTAINING NAMES/RELATIVE RANGE NAMES | Excel Discussion (Misc queries) | |||
Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) |