Hi

I have an array of strings representing named ranges. I want to use these strings to select the ranges like this:

Range(rangeNames(i) ).Select

but it generates an error. Am I on the right track or is this type of operation impractical or impossible in VBA?

Thanks in advance

Just prefiz the Range with the Sheet Object

Like

Activesheet.Range(rangeNames(i) ).Select

or

Worksheets(1).Activesheet.Range(rangeNames(i) ).Select

It should work

Cheers
Shasur

http://www.vbadud.blogspot.com