Named ranges in macros?

[fverlaine]

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

 

[Dave Peterson]

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

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

 

[Niek Otten]

Range("Test").select

 

[fverlaine]

Thanks thats great