| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
changing active cell
Can I move the active cell around in VBA like I use to do in Lotus? ie up3,
right7 etc |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
changing active cell
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
changing active cell
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
changing active cell
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
changing active cell
Użytkownik "doug" napisał w wiadomo¶ci ... 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 maybe ActiveCell.Offset(-3, 7) goes out of spredsheet? mcg |
|
#6
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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
changing active cell
I thought that was what I was doing. What would the VBA code be to insert a
row and be positioned in the A column of that row from anywhere in the worksheet? "Tom Ogilvy" wrote: 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 |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
changing active cell
Sub aa()
Rows(ActiveCell.Row).Insert Cells(ActiveCell.Row, 1).Select End Sub -- Regards, Tom Ogilvy "doug" wrote in message ... I thought that was what I was doing. What would the VBA code be to insert a row and be positioned in the A column of that row from anywhere in the worksheet? "Tom Ogilvy" wrote: 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 |
| Reply |
| 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 | |||
Linear Mode
