Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting Worksheet name in Reference Style
I want to get the address of a cell I am referencing. If I use
Address(external=:True) then I get the workbook name included in the reference. If I use AddressLocal I get just the row/column reference. How can I get the address where it looks like =TRAVEL!$A$10, where TRAVEL is the name of the worksheet where the cell resides? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Req help on Formula or vb in excel to calculate between reference style and formula style tia sal2 | Excel Discussion (Misc queries) | |||
Req help on Formula or vb in excel to calculate between reference style and formula style tia sal2 | Excel Worksheet Functions | |||
R1C1 reference style | Excel Discussion (Misc queries) | |||
can a1 reference style and r1c1 style be used in same formula? | Excel Worksheet Functions | |||
R1C1 reference style | Excel Discussion (Misc queries) |