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? |
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? |
All times are GMT +1. The time now is 12:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com