Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Address
How would I define the cell address of the cell above my
activecell? Thanks in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Address
Try this
MsgBox ActiveCell.Offset(-1, 0).Address -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "Thomas" wrote in message ... How would I define the cell address of the cell above my activecell? Thanks in advance |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Address
Is this what you want?
Sub defineabove() x = ActiveCell.Offset(-1).Address MsgBox x End Sub "Thomas" wrote in message ... How would I define the cell address of the cell above my activecell? Thanks in advance |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Address
One way: ActiveCell(0, 1).Address
Alan Beban Thomas wrote: How would I define the cell address of the cell above my activecell? Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
=HYPERLINK("#"&CELL("address", ADDRESS(MATCH(VALUE(B3),QuoteNotes, | Excel Worksheet Functions | |||
=HYPERLINK("#"&CELL("address", ADDRESS(MATCH(VALUE(B3),Range ... ? | Excel Worksheet Functions | |||
Return cell address of a cell based on contents of cell. | Excel Worksheet Functions | |||
How to create table of cell names with the name's cell address | Excel Discussion (Misc queries) | |||
How make hyperlink refer to cell content rather than cell address. | Excel Discussion (Misc queries) |