View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bill Kuunders
 
Posts: n/a
Default 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?