ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Macro won't move in proper progression (https://www.excelbanter.com/excel-discussion-misc-queries/56974-macro-wont-move-proper-progression.html)

Laurahoney

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?

Bill Kuunders

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