| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
need help with macro -move cursor down then home
Hi all
can someone help me with code to move the cursor down a row and to column 2? I've been using ActiveCell.Offset(0, -3).Select but it has flaws , I need it to go to the 2nd col from left TIA |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Correction need help with macro -move cursor down then home
correction that should read
ActiveCell.Offset(1, -3).Select "Ftca" wrote in message ... Hi all can someone help me with code to move the cursor down a row and to column 2? I've been using ActiveCell.Offset(0, -3).Select but it has flaws , I need it to go to the 2nd col from left TIA |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
need help with macro -move cursor down then home
Try
activecell.End(xlToLeft).Offset(1,1).Select GB "Ftca" wrote in message ... Hi all can someone help me with code to move the cursor down a row and to column 2? I've been using ActiveCell.Offset(0, -3).Select but it has flaws , I need it to go to the 2nd col from left TIA |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
need help with macro -move cursor down then home
thanks GB
fo replying I will try this now Peter "GB" wrote in message ... Try activecell.End(xlToLeft).Offset(1,1).Select GB "Ftca" wrote in message ... Hi all can someone help me with code to move the cursor down a row and to column 2? I've been using ActiveCell.Offset(0, -3).Select but it has flaws , I need it to go to the 2nd col from left TIA |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
need help with macro -move cursor down then home
Good as Gold
Thanks that worked!! "GB" wrote in message ... Try activecell.End(xlToLeft).Offset(1,1).Select GB "Ftca" wrote in message ... Hi all can someone help me with code to move the cursor down a row and to column 2? I've been using ActiveCell.Offset(0, -3).Select but it has flaws , I need it to go to the 2nd col from left TIA |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
need help with macro -move cursor down then home
More reliable might be:
Cells(ActiveCell.Row+1,2).Select Doesn't depend on values being in other cells. -- Regards, Tom Ogilvy "Ftca" wrote in message ... Good as Gold Thanks that worked!! "GB" wrote in message ... Try activecell.End(xlToLeft).Offset(1,1).Select GB "Ftca" wrote in message ... Hi all can someone help me with code to move the cursor down a row and to column 2? I've been using ActiveCell.Offset(0, -3).Select but it has flaws , I need it to go to the 2nd col from left TIA |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I get the cursor to move to cell A1 when I press home key | Excel Discussion (Misc queries) | |||
| move cursor in excle using macro | Excel Discussion (Misc queries) | |||
| macro to move cursor one cell right | New Users to Excel | |||
| Make a macro of keystrokes. ie. F2,Shift & Home & right cursor,de. | Excel Worksheet Functions | |||
| Easy question: macro to move cursor one to the right | Excel Programming | |||
Linear Mode
