Hi everyone! So a small VBA snippet that I've used for various things over the years has stumped me today. Instead of looking for a plain cell value like I normally do, today I am looking for the value of a formula. Let's say my current cell (C5) value is:
Cell: C5
Please Login or Register to view this content.
I'm then using the below VBA to look for the word "Apples" throughout all of column C (not just C5, or a small range).
Please Login or Register to view this content.
The problem I'm finding is, the formula I've filled down a huge range within column C is what is becoming the value of any given cell in that column, not the actual result of the formula ("Apples" or "Oranges"). I've looked up several things online, yet can't seem to find an easy answer to finding the resulting cell value (not the formula) for the above type of script (where the syntax is 'If Target.Value = "Apples" Then....')
Any ideas on how to cleanly solve this? Thanks so much everyone!
Bookmarks