Filter range, copy range (not entire column), paste in another worksheet

Hi,

I want to filter range F14:I58, based on I having a value. Then copy the filtered selection and paste it at the bottom of another worksheet.
Using the below code I would get an error (I59 also contains a value in merged cells. I don't want anything below 58 to be copied) - so I would get the error 'Cannot do that to part of a merged cell' as it tried to copy I59 with the offset rule.
I solved this by adding a blank, hidden row between I58 and I59, which worked for a few days.
Now if I13:I58 is all blank, it will filter to nothing, but then copy the entire F13:I58 and paste it all, ignoring the filter.
Any help?

Please Login or Register  to view this content.

I don't understand your answer sorry -

Column I contains date values.
The criteria/ filter is working perfectly - If I step through the code, any time I has a date, those rows remain.
If there are no dates in I - the entire table disappears as it should.
If I contains dates, the code does what it should and only copies those rows with a date to the new sheet.
The only problem is when the whole column I is blank - then the table is filtered to nothing, but the copy still selects all of the hidden cells, instead of copying nothing like it should