Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro won't move in proper progression
I created a macro to place a border on the left "wall" of a cell and then
move my cursor 3 cells to the right and stop. Instead, each time I use the macro, the cursor returns to the original cell and I have to move over to where it should have moved. Is there some way I can make the macro move the cursor correctly? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro won't move in proper progression
Sub Macro1()
With Selection.Borders(xlEdgeLeft) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = xlAutomatic End With ActiveCell()(1, 4).Select End Sub This will add the border to the current active or selected cell. -- Greetings from New Zealand Bill K "Laurahoney" wrote in message ... I created a macro to place a border on the left "wall" of a cell and then move my cursor 3 cells to the right and stop. Instead, each time I use the macro, the cursor returns to the original cell and I have to move over to where it should have moved. Is there some way I can make the macro move the cursor correctly? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Help In Excel | Excel Discussion (Misc queries) | |||
Highlight Range - wrong macro, please edit. | Excel Worksheet Functions | |||
move to another cell within a subtotal report within a macro | Excel Worksheet Functions | |||
Relative Cell position NOT working with or without macro | Excel Discussion (Misc queries) | |||
enter data in cell which will start macro to move data to sheet2 | Excel Discussion (Misc queries) |