What i want is the equivalent of the VBA formula property, on the Excel sheet.
For instance in VBA i can say the following
x=Range("A1").formula
And it puts the text of the formula in cell A1 into the variable x.
I'd like to put the text of the formula in cell A1 into cell B1, say. Not as a formula, but as text. And with a formula, not by copy/paste. (I want to fill the formula down).
Is there a way?
Thank you.
For instance in VBA i can say the following
x=Range("A1").formula
And it puts the text of the formula in cell A1 into the variable x.
I'd like to put the text of the formula in cell A1 into cell B1, say. Not as a formula, but as text. And with a formula, not by copy/paste. (I want to fill the formula down).
Is there a way?
Thank you.