Hi

This line of code is copying from row 3 meaning without heading and first first row of information:

.SpecialCells(xlCellTypeVisible).Offset(1).Copy

This line of code is copying visible cells with heading:

.SpecialCells(xlCellTypeVisible).Copy


I need the macro to copy the filtered cells without the heading but from the first row. For some reason the offset(1) is skipping the first row of data.

Please help out here if you can.

Thanks