Jay,

1) ActiveCell.Offset(0, 5).Select

2) ActiveCell.Offset(-5,0).Select


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"jay dean" wrote in message
...


When I call "offset(some number)" on some defined range as in "Set rng
= rng.offset(5)" it offsets the range downwards.

How should I code it if I want the range to :

(1) offset(5) to the right

(2) offset(5) upwards.

Any assistnce would be appreciated. Thanks.

Jay Dean

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