I'm on a short deadline, so I need help right away if possible. I have
a macro creating an advanced filter that extracts data from a hidden
datasheet based on a selected cell in a source sheet. On previous
sheets, I tested for data to filter using info on the source sheet, but
I have a new source sheet that doesn't have the info on it. Is there a
way to trap the filter results if there is no applicable data and send
it to the MsgBox I already created that says there's no revelant data
for that county? Right now, I'm getting a macro error 1004,
"Application defined or object defined error" when it tries to apply
the filter.
Thanks for the help!