Tag/Identify Cells

[joe.engel]

Is there a way to tag/identify cells with the same value? When
creating cell values off of cells with the same value, I need a way to
distinguish that they are/are not values created from the same cell.
Ex. :
(A1=10, A2=20, A3=30, A4=20)

Cells(1,2)=Cells(2,1)
Cells(1,3)=Cells(3,1)
Cells(1,4)=Cells(1,1)

Cells(1,2)=Cells(4,1)
Cells(1,3)=Cells(3,1)
Cells(1,4)=Cells(1,1)

Both of these produce the same results for cell "B2", although they
came from different cells in column A. I do not need to know where
they came from. Just that the values are from different cells.

Any help is appreciated.

Joe

 

[Bill Renaud]

Show Auditing Toolbar, then click on the "Show Precedents" button.

Or, double-click the cell. Excel will select all cells that are referenced
in the formula, unless this default behavior has been overridden by an
event macro.

Or, write a macro to cycle through all cells with formulas and look for
formulas that all have the same cell references in them ("B2"). (Not easy.)

 

[joe.engel]

Show Auditing Toolbar, then click on the "Show Precedents" button.

Or, double-click the cell. Excel will select all cells that are referenced
in the formula, unless this default behavior has been overridden by an
event macro.

Or, write a macro to cycle through all cells with formulas and look for
formulas that all have the same cell references in them ("B2"). (Not easy.)

Thanks Bill. I'm going to write the macro that checks precedents for
the cells in question.