Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Hello,

No, you can't using formulas. In fact you even don't copy anything using something like =A1. This is just a reference to cell A1, just like a hyperklink on the web doesn't copy the content but referreing to some content on another site, =A1 does point to the content of cell A1.

Hello,

No, you can't using formulas. In fact you even don't copy anything using something like =A1. This is just a reference to cell A1, just like a hyperklink on the web doesn't copy the content but referreing to some content on another site, =A1 does point point to the content of cell A1.

Hello,

No, you can't using formulas. In fact you even don't copy anything using something like =A1. This is just a reference to (the content of) cell A1, just like a hyperklink on the web doesn't copy the content but referreing to some content on another site, =A1 does point to the content of cell A1.

Hello,

No, you can't using formulas. In fact you even don't copy anything using something like =A1. This is a reference to (the content of) cell A1, just like a hyperklink on the web doesn't copy the content but referreing to some content on another site, =A1 does point to the content of cell A1. and does not copy its conten to the cell containing the formula. The content of a referring cell is a formula.

Hello,

No, you can't using formulas. In fact you even don't copy anything using something like =A1. This is a reference to (the content of) cell A1, just like a hyperklink on the web doesn't copy the content but referreing to some content on another site, =A1 does point to the content of cell A1 and does not copy its conten to the cell containing the formula. The content of a referring cell is a formula.

There are no formulas referring to the format of another cell, thus you can't do what you want to achieve using a formula. To put it other way round: You would need to write a macro to peform a copy of the format of another cell.