Macro for Range Names
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.
|