Excel Macros
 

What command should I use in an Excel visual basic macro to move the current
cell to the left by 1

Excel Macros
 

ActiveCell.Offset(0,-1).Select


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Paul Bond" wrote:

What command should I use in an Excel visual basic macro to move the current
cell to the left by 1

Excel Macros
 

Sub Macro1()
ActiveCell.Cut
ActiveCell.Offset(0, -1).Select
ActiveSheet.Paste
End Sub

--
Gary''s Student - gsnu200797

Excel Macros
 

Sub moveactivecell()
ActiveCell.Cut ActiveCell.Offset(, -1)
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Paul Bond" wrote in message
...
What command should I use in an Excel visual basic macro to move the
current
cell to the left by 1