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!