Excel Macros

  • Thread starter Thread starter Paul Bond
  • Start date Start date
P

Paul Bond

What command should I use in an Excel visual basic macro to move the current
cell to the left by 1
 
Sub Macro1()
ActiveCell.Cut
ActiveCell.Offset(0, -1).Select
ActiveSheet.Paste
End Sub
 
Sub moveactivecell()
ActiveCell.Cut ActiveCell.Offset(, -1)
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

'Cannot insert object' message when I try to put a button on a worksheet 7
Excel 2007: Help creating a macro that will run Solver? 3
copy author in cell 1
Excel version in Office Home & Student full featured?? 1
Imported Visual Basic Module - Save Macros for use in Excel 1
Excel Macro-enabled Workbook 2
Visual Basic Function works fine in Excell 2003 but not in Excel 2 8
macro using cell value 4

Back
Top