Copy Specific Columns from a Filtered Range

Originally Posted by Arkadi

Saarang, I don't quite follow... what condition on the sheet is causing the error to happen?

Hi Arkadi,

I've included comments in my workbook attached to my below post against your code. Refer to your module which I've renamed as "Export_Dumps_1".

I tried executing your module by setting breakpoints at specific parts of the code after integrating it with my existing code, but I get VBA run-time error '13' Type Mismatch error due to formulas getting auto-calculated and resulting in #VALUE! filled in the cell being compared against the values "#N/A" and "Prod Only" or "Innov Only".