| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Macros
What command should I use in an Excel visual basic macro to move the current
cell to the left by 1 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Macros
Sub Macro1()
ActiveCell.Cut ActiveCell.Offset(0, -1).Select ActiveSheet.Paste End Sub -- Gary''s Student - gsnu200797 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 macros - how to merge 5 macros together into one | Excel Discussion (Misc queries) | |||
| Macros warning always shows up, even if all macros removed | Excel Discussion (Misc queries) | |||
| Macros - copying macros from one computer to another | Excel Discussion (Misc queries) | |||
| Training: More on how to use macros in Excel: Recording Macros | Excel Worksheet Functions | |||
| macros in excel | Excel Discussion (Misc queries) | |||
Linear Mode
