| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
create a macro that opens, edits then closes cell
I want to create a macro that opens a cell, allows me to edit the cell (with
a pause for input) then close the cell and go down 4 lines. I come from a Lotus background where I could just make the formula, give it a shortcut key and perform the task (<f2<home<rightIF($AG$<pause=,,<en ter<down<down<down<end) Starting cell contents =IF($AG$26="W",$AE$26,$AE27) Ending cell contents after running macro =IF($AG$24="","",IF($AG$24="W",$AE$24,$AE25)) Some help would be great Dale Saunders |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hyperlink to pdf opens and closes | Excel Discussion (Misc queries) | |||
| excel Visual basic opens then closes for users | Excel Discussion (Misc queries) | |||
| File opens another file runs macro and closes | Excel Programming | |||
| I want to create a macro that opens the Find Box on the sheet | Excel Programming | |||
| Creating a .bat file that opens, pauses & closes MS Excel | Excel Programming | |||
Threaded Mode
