Range SearchRng is a predefined range that I have!
If I want to search SearchRng for text "Test" then I would use this code
However, instead of "Test", I want to find Cell with Interior.ColorIndex = 4![]()
Set rFind = SearchRng.Find("Test", LookIn:=xlValues, Lookat:=xlWhole, _ SearchOrder:=xlNext, MatchByte:=True)
Would you help please!?
Thank you,
NTB
Bookmarks