ActiveCell.Offset(-1, -10).Select

Regards,
Paul

"jsd219" wrote in message
oups.com...
Can anyone tell me how to set a range offset? i am trying to write a
script that will start from the active cell and perform an action 1 row
above and several columns to the left.

example:

if cell "N100" is the active cell my script will go up to "N99" and
over to column "D" then perform its action.

God bless
jsd219