VBA autofilter works then pastes all cells to destination negating it. Please Help!

  • I have the following macro that is intended to filter the data tab based on the two specified criteria and then paste the remaining lines into the report. The filters work properly but it is pasting even the hidden rows into the report and I can't figure out how to get it to only paste the visible lines. I am pasting my code below. Has anyone experienced this issue before or know how I might resolve it?

  • I believe that is needed but I spent all night trying to figure out where to put it. I've resorted to haphazardly inserting it and testing it to find the solution but have not been successful.

  • I believe that the problem lies within this smaller section of code. perhaps I need to re define my range after the data is filtered rather than using dataArray again?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!