Referencing worksheet question

  • Thread starter Thread starter rl
  • Start date Start date
R

rl

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
 
msg = Application.Substitute(activeCell.formula,"!",".")

or, in Excel 2000 and later use the replace function.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extracting a Part of a Formula as Text 5
Clarification need, not just by me 3
Replace worksheet 1
Help with an IF Formula 1
Named Formula across multiple worksheets 4
copy WB without VBA: copied sheets link back to source WB 2
Referencing repeating non-consecutive rows 2
When pasting formulas to other WB, the references still linked to old WB ... 2

Back
Top