D
Dennis
Using XL 2003 & 97
Not yet successful at trying to write VBA code to find all formula cells
with a variable AND a constant.
Also, I would like each identified cell to background-fill with yellow.
Example: (Cells A2 & A3 are background-filled yellow)
A1 = B1+C1 (Not selected - background no-fill)
A2 = B2+10000+C2 (Selected - background - yellow)
A3 = B1+C1+15000 (Selected - background - yellow)
TIA Dennis
Not yet successful at trying to write VBA code to find all formula cells
with a variable AND a constant.
Also, I would like each identified cell to background-fill with yellow.
Example: (Cells A2 & A3 are background-filled yellow)
A1 = B1+C1 (Not selected - background no-fill)
A2 = B2+10000+C2 (Selected - background - yellow)
A3 = B1+C1+15000 (Selected - background - yellow)
TIA Dennis