Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks to everyone who replied. This solves my problem.
-- Howard "Mike H" wrote: Hi, Alt+F11 to open VB editor, Right click 'ThisWorkbook' and insert module and paste the code in Sub Move_me() ActiveCell.Offset(9).Select End Sub Back on the worksheet Tools|Macro - Macros - navigate to the macro then 'Options' and assign the shortcut CTRL+D -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Howard" wrote: I need a snippet of code that will (when you use ctrl-d) look at the active cell, move the cursor down 9 cells (same column) and make that cell the active cell, no matter where you start on the spreadsheet. Any ideas? Thanks to everyone. -- Howard |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
moving active cell on another sheet | Excel Programming | |||
Moving left/right from active cell | Excel Programming | |||
Need Help With Moving Active Cell | Excel Programming | |||
Moving active cell after copy | Excel Programming | |||
Moving active cell | Excel Programming |