| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
address location
I am preparing a formula which needs the address of the first cell located
above the active cell that contains information . The key strokes would normally be "=" then "ctrl + {up}" then "{enter}". What macro language would achieve this result. -- l-hawk |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
address location
hi
something like activecell.end(xlup).select "hawki" wrote: I am preparing a formula which needs the address of the first cell located above the active cell that contains information . The key strokes would normally be "=" then "ctrl + {up}" then "{enter}". What macro language would achieve this result. -- l-hawk |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
address location
Thanks!
-- l-hawk "FSt1" wrote: hi something like activecell.end(xlup).select "hawki" wrote: I am preparing a formula which needs the address of the first cell located above the active cell that contains information . The key strokes would normally be "=" then "ctrl + {up}" then "{enter}". What macro language would achieve this result. -- l-hawk |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro - save to current location vs excel default location | Excel Discussion (Misc queries) | |||
| Using Dynamic Cell Address As Formula Location | Excel Worksheet Functions | |||
| Cell Address Location | Excel Worksheet Functions | |||
| Mouse Location, Movement and Spreadsheet Location | Excel Programming | |||
| Using =address to provide address location for =average | Excel Worksheet Functions | |||
Linear Mode
