Thread: Regex Pattern to extract Sheet Name from .Address(external:=True)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ExcelMonkey ExcelMonkey is offline
external usenet poster
  
Posts: 553
Default Regex Pattern to extract Sheet Name from .Address(external:=True)
I need a quick way to extract the sheet name from this external address"

'[ABC.xls]Sheet1'!$C$2

A quick way would be to use a regex pattern which takes out everything
between the "]" and "!". Does anyone know what this pattern would look like?

Any ideas?

Thanks

EM

Reply With QuoteReply With Quote