I am using this macro:
Function CellFormula(c)
CellFormula = c.Formula
End Function
to reference where I am pulling my data from in a column separate from where the data is actually presented.
In example, in cell A1 of Sheet 1, "1,500,000" is displayed which I pulled cell B3 of the 2nd tab in my workbook called "2. Data". With the macro, I am able to display "='2. Data'!B3" in cell B1 of Sheet 1 - exactly what I want to do. However, instead of reading "='2. Data'!B3," I would like the reference to simply be '2. B3'. Is there any simple way to do this within my macro? Because in some cases I will be referencing more than one cell, and cells with different digit lengths, I cannot simply use a left/right formula.
Thank you!!
Function CellFormula(c)
CellFormula = c.Formula
End Function
to reference where I am pulling my data from in a column separate from where the data is actually presented.
In example, in cell A1 of Sheet 1, "1,500,000" is displayed which I pulled cell B3 of the 2nd tab in my workbook called "2. Data". With the macro, I am able to display "='2. Data'!B3" in cell B1 of Sheet 1 - exactly what I want to do. However, instead of reading "='2. Data'!B3," I would like the reference to simply be '2. B3'. Is there any simple way to do this within my macro? Because in some cases I will be referencing more than one cell, and cells with different digit lengths, I cannot simply use a left/right formula.
Thank you!!
