View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Susan Susan is offline
external usenet poster
 
Posts: 1,117
Default Marco command to name a range?

if you turn on the macro recorder
do what you want to do
and then turn it off
and then look at the code it produced, it will give you some ideas of
how to set the range.
then you can name the range.
hth
susan


On Apr 4, 7:52 am, wrote:
I'm trying to create a macro command that will create a range name for
a range that is set by the end - right - end - down process (since the
dimensions will change each time it's run) I'm sure it's easy, but
I'm just a rookie at this.