View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Doug Doug is offline
external usenet poster
 
Posts: 460
Default changing active cell

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