Named ranges in macros?
 

How do I write a macro refering to a named range in the sheet rather
than the range itself. Ie. I have named cells A1 to F7 as "test". When
writing a macro I want to refer to "test" rather than
Range("A1:A7").select?


--
fverlaine
------------------------------------------------------------------------
fverlaine's Profile: http://www.excelforum.com/member.php...o&userid=29637
View this thread: http://www.excelforum.com/showthread...hreadid=493469

Named ranges in macros?
 

worksheets("sheet1").range("Test").clearcontents

Most times, you don't have to select a range to work on it.

fverlaine wrote:

How do I write a macro refering to a named range in the sheet rather
than the range itself. Ie. I have named cells A1 to F7 as "test". When
writing a macro I want to refer to "test" rather than
Range("A1:A7").select?

--
fverlaine
------------------------------------------------------------------------
fverlaine's Profile: http://www.excelforum.com/member.php...o&userid=29637
View this thread: http://www.excelforum.com/showthread...hreadid=493469

--

Dave Peterson

Named ranges in macros?
 

Range("Test").select

--
Kind regards,

Niek Otten

"fverlaine" wrote
in message ...

How do I write a macro refering to a named range in the sheet rather
than the range itself. Ie. I have named cells A1 to F7 as "test". When
writing a macro I want to refer to "test" rather than
Range("A1:A7").select?


--
fverlaine
------------------------------------------------------------------------
fverlaine's Profile:
http://www.excelforum.com/member.php...o&userid=29637
View this thread: http://www.excelforum.com/showthread...hreadid=493469

Named ranges in macros?
 

Thanks thats great :)


--
fverlaine
------------------------------------------------------------------------
fverlaine's Profile: http://www.excelforum.com/member.php...o&userid=29637
View this thread: http://www.excelforum.com/showthread...hreadid=493469