| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
moving cursor in a macro
How do I have the macro move the cursor up one row from any cell.
ie: If cursor was on A13 before I run the macro and I want it to move A12 or if cursor was on B23 before I run the macro and I want it to move to B22 p.s. I've tried using the up arrow as well as Shift Enter and neither work Amanda |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
moving cursor in a macro
The macro should have recorded the move if it was made while recording the
macro. But none the less, it looks like you want it to move up 1 row, remaining in the same column. Add this line of code just before the End Sub statement ActiveCell.Offset(-1,0).Activate should do it. "Amanda" wrote: How do I have the macro move the cursor up one row from any cell. ie: If cursor was on A13 before I run the macro and I want it to move A12 or if cursor was on B23 before I run the macro and I want it to move to B22 p.s. I've tried using the up arrow as well as Shift Enter and neither work Amanda |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
moving cursor in a macro
Perfect! Worked like a charm! you are a life saver!!
"JLatham" wrote: The macro should have recorded the move if it was made while recording the macro. But none the less, it looks like you want it to move up 1 row, remaining in the same column. Add this line of code just before the End Sub statement ActiveCell.Offset(-1,0).Activate should do it. "Amanda" wrote: How do I have the macro move the cursor up one row from any cell. ie: If cursor was on A13 before I run the macro and I want it to move A12 or if cursor was on B23 before I run the macro and I want it to move to B22 p.s. I've tried using the up arrow as well as Shift Enter and neither work Amanda |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
moving cursor in a macro
ActiveCell.Offset (-1,0).Select
Aqib Rizvi |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| moving the cursor in a macro | Excel Discussion (Misc queries) | |||
| moving cursor | Excel Worksheet Functions | |||
| moving cursor | New Users to Excel | |||
| Moving cursor around excel | Excel Discussion (Misc queries) | |||
| Moving Cursor within same cell | Excel Discussion (Misc queries) | |||
Linear Mode
