simplifying if statement for filter and finding no data

[alexcrofut]

Hello everyone,

I have a macro which builds a report to be sent out daily, however some days there are no updates in certain categories.
The macro copies over certain template lines from a template report, then filters the formatted data sheet and copies the rows over to a report
the problem is that certain days the filter returns no rows, so I put in a lengthy if statement


Here is the code I am currently using, I would like to simplify it (the entire macro would run this about 20 times over for different sections)

Please Login or Register  to view this content.

any ideas???

Thanks

[xladept]

Maybe:

Please Login or Register  to view this content.