Using a macro to set a range name in EXCEL
 

I cannot figure out how to define a range name with a
macro. The range is variable

Using a macro to set a range name in EXCEL
 

Range(Cells(1,1),Cells(1,1).End(xldown)).Name = "RangeName"

--
Regards,
Tom Ogilvy


Eric Tepen wrote in message
...
I cannot figure out how to define a range name with a
macro. The range is variable

Using a macro to set a range name in EXCEL
 

Eric,

A simple way to name a range would be:

range("A1:C5").Name = "TestRange"

The range is variable
In what way???
Rows?
Columns?

There are a lot of variations on the above.
Post back with more info and someone will be sure to help you out.

John

"Eric Tepen" wrote in message
...
I cannot figure out how to define a range name with a
macro. The range is variable