i'm using the .find method against a range on another worksheet (works well)...
but when i filter the range first (e.g., only give me the country of USA), my results are not 100% correct (sometimes i have to run the .find code a second time and then it returns correctly...???)...
?does this make sense?
--maybe i should not be using the .find method against a filtered range?
(i have tried running the find against the entire worksheet and then against a dynamic range name-adusting after the filter)
???
thank you.