View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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