View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SamDev SamDev is offline
external usenet poster
 
Posts: 10
Default 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.