Hello,
I am trying to have a warning for a macro that I'm running to alert the user if there isn't a match on Gender description. I am using a lookup cell within the workbook that sets a filter and pulls the applicable data to put into a report. If the macro doesn't find the lookup value, my workbook basically crashes (probably due to beginner coding). Any way, when the values are set correctly it works great some I'm doing with what I've got. Here's my issue, the following code is finding the word "Men" in Women and allowing the macro to continue. Is there a more specific function in vba that will take the "absolute" value of the lookup cell?
Whe in set the filter in the workbook, I was able to switch "Search" for "Find" and it worked. With this being a "find" statement already, I'm a bit lost.
Thanks
Bookmarks