Copy Filtered data and stop macro when filter is empty

[dobracik]

Hi all :-)

I was wondering, if here is anybody, who could help me with following code.

==> I have a code to filter columns based on criteria which should be copy pasted to other sheet. If there are any results, no problem. But I'm not able to modify macro, that if filter is empty, that in the end I do not have any results, which code to use to stop it?

Thanks,
Andy

[Kenneth Hobson]

If the SpecialCells visible rows range's Rows.count =1 then exit. That is if you include the title row...

[dobracik]

Can you just help me how to write line for visible cells >=1 ?
I'm done today :-(

[jaslake]

Hi dobracik

Post the Code your using...one of us will modify for you.

[Kenneth Hobson]

Since you did not post code, the only way I might be able to help is to guess:

Please Login or Register  to view this content.

[dobracik]

Hi both :-)
will try to use Kenneth code, but just in case here I'm sending mine.

Please Login or Register  to view this content.

So if filter is empty, stop macro otherwise continue with copy pasting. :-)

Thanks a lot

[jaslake]

Hi Andy

See if this works for you...

Please Login or Register  to view this content.

[dobracik]

Waaaauuuu, nic work. It's working, thanks a lot :-)

[jaslake]

You're welcome...glad I could help. Thanks for the Rep.