I was looking at some explanations for using find function in vba. This just seems like a very complicated way of doing a find and replace. Am I missing something?
![]()
Please Login or Register to view this content.
I was looking at some explanations for using find function in vba. This just seems like a very complicated way of doing a find and replace. Am I missing something?
![]()
Please Login or Register to view this content.
I think the font colour being changed is what complicates that code, you could do that with the standard Replace function.
If posting code please use code tags, see here.
FWIW since you are also wanting to change the font color you could accomplish this fairly quickly with autofilter.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks