Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referencing worksheet question
I have a question regarding the exclamation mark in a formula when you
reference another worksheet's cell (ie... Sheet2!A1 ) Why is an exclamation mark used? History behind this? Is there anyway that an excel setting could replace this '!' with something another character? I'm hoping to read the formula using VBA but would like to see it in a different format such as "Sheet2.A1" and don't want spend the time to search & replace character if unnecessary.... please advise.... Regis |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referencing worksheet question
msg = Application.Substitute(activeCell.formula,"!",".")
or, in Excel 2000 and later use the replace function. -- Regards, Tom Ogilvy "rl" wrote in message ... I have a question regarding the exclamation mark in a formula when you reference another worksheet's cell (ie... Sheet2!A1 ) Why is an exclamation mark used? History behind this? Is there anyway that an excel setting could replace this '!' with something another character? I'm hoping to read the formula using VBA but would like to see it in a different format such as "Sheet2.A1" and don't want spend the time to search & replace character if unnecessary.... please advise.... Regis |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula & Referencing Question | Excel Worksheet Functions | |||
Advanced Referencing Question | Excel Discussion (Misc queries) | |||
Question on Referencing | Excel Discussion (Misc queries) | |||
CountIF() in Worksheet B while referencing cells in Worksheet A | Excel Worksheet Functions | |||
CountIF() in Worksheet B while referencing cells in Worksheet A | Excel Worksheet Functions |