Hi Buffyslay,

If n = 40, what is the address of the intended selection range?


---
Regards,
Norman



wrote in message
...
hi there

what i needed to do was

ActiveSheet.Range("E9").Activate
ActiveCell.Offset(0, n).Select
ActiveCell.Range("A1:A250").Select

where the the A1 actually refers to the active cell not the actual call
A1! odd behaviour i know

but thanks for the reply


_________________________________________

Willow: "I knew it! I knew it! Well, not in the sense of having the
slightest idea, but I knew there was something I didn't know."

http://www.buffyslay.co.uk

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