Macro Using Named Cell
 

Sure, here it is:

Say your range is named "range1"; the code is
Range("range1").Select

to select that range.
---
Mark Bigelow

http://hm.imperialoiltx.com

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!