| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Row select mode to highlight active row of active cell | Excel Discussion (Misc queries) | |||
| Changing an active cell format in VBA | Excel Discussion (Misc queries) | |||
| printing only active range (changing) | Excel Discussion (Misc queries) | |||
| Changing active selection cursor | Excel Discussion (Misc queries) | |||
| Changing active cell to a color | Excel Programming | |||
Threaded Mode
