Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tag/Identify Cells
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.) -- Regards, Bill Renaud |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Tag/Identify Cells
On Sep 29, 4:34 pm, "Bill Renaud"
wrote: 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.) -- Regards, Bill Renaud Thanks Bill. I'm going to write the macro that checks precedents for the cells in question. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Identify Text on two cells | Excel Discussion (Misc queries) | |||
formula to identify specific cells | Excel Discussion (Misc queries) | |||
How do I identify blank cells? | New Users to Excel | |||
Identify if a cell is referenced by other cells | Excel Worksheet Functions | |||
how to identify cells containing formulas | Excel Programming |