Duplicate of cell

[Fonzie]

Is there a way to run a macro or write a formula in Excel XP so a certain cell is an exact duplicate of another cell, formatting and coloring included? For example, D1 is always the same as A1 no matter what changes are made to A1.

 

[SkipVought]

Hi,

The Worksheet_Change event will fire any time a VALUE changes on the sheet.

   [A1].copy [D1]

CAVEAT: There is no event for FORMATS changing on a sheet.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[Fonzie]

Is there not a way to set the ColorIndex of a cell = ColorIndex of a different cell? If I can get the value of the cell and the fill color, that is all I really need.

 

[SkipVought]

If you tried the solution, you would see that the VALUE and the FORMATS are copied when the VALUE changes.

However, if you just change the FORMAT, there is no event to convey that change to the other cell.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]