Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What does Address(external:=True) mean? | Excel Programming | |||
Another Problem with Regex Pattern | Excel Programming | |||
Help with a regex pattern please | Excel Programming | |||
Help with a Regex Pattern | Excel Programming | |||
When do I need Rng.Address(External:=True) | Excel Programming |