View Single Post
  #2 (permalink)  
Old November 13th, 2006, 07:35 AM
Shasur Shasur is offline
Friend of Wrox
Points: 3,060, Level: 23
Points: 3,060, Level: 23 Points: 3,060, Level: 23 Points: 3,060, Level: 23
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Sep 2005
Location: , , .
Posts: 812
Thanks: 1
Thanked 53 Times in 49 Posts
Default

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
Reply With Quote