changing active cell
Selection.EntireRow.Insert
ActiveCell.Offset(0,-3).Select
but hopefully you will give up this approach and learn how to program in
VBA -- which doesn't mimic cursoring around the worksheet.
--
Regards,
Tom Ogilvy
"doug" wrote in message
...
Starting at cell L51, the first line works good when alone,
Selection.EntireRow.Insert
ActiveCell.Offset(0,-3)
"Stuart" wrote:
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
|