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.
|