Perhaps you might care to show the code which produces
this error, then?

"doug" wrote in message
...
Thanks but that returns a compile/syntax error.

"Stuart" wrote:

Perhaps ActiveCell.Offset(-3, 7) ?

Regards.

"doug" wrote in message
...
Can I move the active cell around in VBA like I use to do in Lotus? ie
up3,
right7 etc