G
Guest
I'd like to use the name of a worksheet, say "postage", as an input variable
in a formula on that worksheet.
For example, assume that I have a worksheet named "Postage", and assume that
'sheetName' is a variable containing the name of the worksheet.
I would want to use this formula: ="Costs of "&sheetName&":"
to create this line of text: 'Costs of Postage:'
Does someone know how to do that, or if it's even possible (preferably
without macros).
in a formula on that worksheet.
For example, assume that I have a worksheet named "Postage", and assume that
'sheetName' is a variable containing the name of the worksheet.
I would want to use this formula: ="Costs of "&sheetName&":"
to create this line of text: 'Costs of Postage:'
Does someone know how to do that, or if it's even possible (preferably
without macros).