Tag/Identify Cells
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
|