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!

Some error trapping should work, something like:

On Error GoTo ErrorHandler

And then:

ErrorHandler:
'code for msgbox

That should work.



*** Sent via Developersdex http://www.developersdex.com ***

I don't know how you extract the filtered data, but I use code like

Set rng = rngToFilter.SpecialCells(xlCellTypeVisible)

so you can test that for Nothing

If Not rng Is Nothing Then

etc.


--

HTH

RP
(remove nothere from the email address if mailing direct)


"davegb" wrote in message
oups.com...
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!