Thread: Getting Worksheet name in Reference Style
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
PCLIVE PCLIVE is offline
external usenet poster
  
Posts: 65
Default Getting Worksheet name in Reference Style
This should give you a good start.

wsName = ActiveSheet.Name
cellAdress = ActiveCell.Address

Where is this to be displayed?


wrote in message
ups.com...
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?



Reply With QuoteReply With Quote