Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Hard Coded Cells
Hi everyone. I have a small piece of code that finds cells that have
hardcoded numbers in them and colors the cell blue. Unfortunately, it only finds "true hardcoded" cells, for example, the number 23456. What it does not find is =A1+23456. I have a huge file that my boss has sporadically edited cells with numbers to make a certain value. I need to find those "edits" and remove them. Any ideas on how to modify the below code to finds the numbers within a formula like =A1+23456? Thank you! Sub ColorCellsOnce() On Error Resume Next Cells.SpecialCells(xlCellTypeConstants, 1).Font.ColorIndex = 5 On Error GoTo 0 End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combo Box / Hard Coded List | Excel Discussion (Misc queries) | |||
Hard coded formula fix, VBA for column ordering | Excel Worksheet Functions | |||
do the same thing to multiple hard coded cells | Excel Worksheet Functions | |||
Index Sheet which summarizes all cells with hard coded data. | Excel Programming | |||
Function to check to see if cell has hard coded data in it | Excel Programming |