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 - 29 Sep 2007 21:34 GMT
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.)

Signature
Regards,
Bill Renaud
joe.engel@hotmail.com - 30 Sep 2007 13:46 GMT
On Sep 29, 4:34 pm, "Bill Renaud" <Bill.No.Spam.Ren...@Comcast.Net>
wrote:
> Show Auditing Toolbar, then click on the "Show Precedents" button.
>
[quoted text clipped - 8 lines]
> Regards,
> Bill Renaud
Thanks Bill. I'm going to write the macro that checks precedents for
the cells in question.