Can I force Excel to fully define formula links?

e.g. I want it to define a Cell, which is the product to two others as:
=currentSheet!A42*currentSheet!B52
instead of just:
=A42*B52

Trouble is I don't know how the worksheet is being created, so I need an
option to tell Excel what to do.

Thanks,
Peter

Hi Peter,

Do you mean you are adding a sheet with code then also with code want write
a formula on some other sheet that refers to the new activesheet. If so for
the sheet name part

"'" & activesheet.name & "'!" & "etc"

there are apostrophes in the quotes.

Regards,
Peter T

"Peter Chatterton" wrote in message
...
Can I force Excel to fully define formula links?

e.g. I want it to define a Cell, which is the product to two others as:
=currentSheet!A42*currentSheet!B52
instead of just:
=A42*B52

Trouble is I don't know how the worksheet is being created, so I need an
option to tell Excel what to do.

Thanks,
Peter