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 |
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 |
All times are GMT +1. The time now is 07:55 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com