Hi
I'm interested in what seems should be a simple macro - It should put an equals sign before the value of each cell in the active array. But I have had little luck as a novice.
Recording the macro does not work. Use of the recorded macro in another cell returns the value of the cell that is similarly offset from the originally referenced cell. If the relative reference in the VBA code is replaced with ActiveCell, the recorded macro places the value of the active cell in single quotation marks and does not fetch the referenced cell value.
To clarify the result I have in mind, take the following for example. Cell C3 holds the value So Far, So Good. A1 has the value C3. After implementing the desired macro, A1 should hold the value So Far, So Good and the function =C3. A similar function would be performed in each cell of an array if multiple cells were selected at initiation.
I would be most interested to see if (and how) this can be coded. Let me know if you would like me to further clarify my question.
Kind regards
i_excel
I'm interested in what seems should be a simple macro - It should put an equals sign before the value of each cell in the active array. But I have had little luck as a novice.
Recording the macro does not work. Use of the recorded macro in another cell returns the value of the cell that is similarly offset from the originally referenced cell. If the relative reference in the VBA code is replaced with ActiveCell, the recorded macro places the value of the active cell in single quotation marks and does not fetch the referenced cell value.
To clarify the result I have in mind, take the following for example. Cell C3 holds the value So Far, So Good. A1 has the value C3. After implementing the desired macro, A1 should hold the value So Far, So Good and the function =C3. A similar function would be performed in each cell of an array if multiple cells were selected at initiation.
I would be most interested to see if (and how) this can be coded. Let me know if you would like me to further clarify my question.
Kind regards
i_excel