Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
highlight cells that have dependents
Hi,
I have a column of cells, some of which have dependents in other sheets in the same workbook, and some of which don't. I'd like to highlight the cells that do have dependents. I've tried using the Dependents and the DirectDependents properties in Visual Basic, but they only seem to work in the active sheet, and all my cells have dependents in other sheets. I have more than 6000 rows, so i wouldn't want to do it manually. Any suggestions? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trace Dependents for range of cells | Excel Discussion (Misc queries) | |||
How to highlight cells... | Excel Discussion (Misc queries) | |||
how do trace dependents for all cells at once? | Excel Discussion (Misc queries) | |||
Highlight Cells | Excel Discussion (Misc queries) | |||
Highlight cells with ctrl-click but only un-highlight one cell | Excel Discussion (Misc queries) |