Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
cell address
I need a code that will record the active cell address in
another cell (say store it in Sheet1 A:1). I then need a code that can later look at the address that is stored in Sheet1 A:1 and go to that referenced cell.??? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
cell address
Hello
Public MyCellAddr As String Sub DefineCellAddress() MyCellAddr = ActiveCell.Address Worksheets("Feuil1").Range("A1").Value = MyCellAddr End Sub Sub GotoMyCellAaddress() Range(MyCellAddr).Select End Sub HTH Cordially Pascal "scrabtree" a écrit dans le message de ... I need a code that will record the active cell address in another cell (say store it in Sheet1 A:1). I then need a code that can later look at the address that is stored in Sheet1 A:1 and go to that referenced cell.??? |
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) |