Trouble with variable range names in excel vba

[danomaniac]

I'm having trouble referencing range names in my code..

I have several ranges named "range01", "range02", "range03" etc.

I want to clear the contents of all the ranges and this is what I have, and it gives me an error 1004 'Method range of object _worksheet failed"

dim rname as string

For i = 1 to 3
rname = "range0" & i
Range(rname).clearcontents
next

Thanks.



"It's more like it is now, than it ever has been."

 

[ClulessChris]

first of all what's in Range01-03?
have you tried dim them as string?

Everybody is somebodys Nutter.

 

[ck1999]

Try this

Range(ActiveWorkbook.Names( rname)).ClearContents

ck1999

 

[SkipVought]

Hi,

works for me.

Try to quallify the Range object with the Worksheet object.

   [b]worksheets("YourSheetName").[/b]Range(rname).clearcontents

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[danomaniac]

Thanks,
Both ways work great. I appreciate it.



"It's more like it is now, than it ever has been."