Thread: [Solved] range.find searchformat doesn't find all cells with any red font
View Single Post
 
Old 11-22-2024, 01:42 PM
brelin brelin is offline Windows 10 Office 2010
Novice
  
Join Date: Nov 2024
Posts: 1
brelin is on a distinguished road
Default range.find searchformat doesn't find all cells with any red font
In the attached xlsm WhyDoesntItFindAct2035 doesn't find the red font in the Act sheet B97. Even if I remove all but the red font from that cell it still won't find it. Any ideas?
Attached Files
File Type: xlsm rangefind searchformat doesnt work.xlsm (167.9 KB, 5 views)
Reply With Quote