Hi

I have an autofilter that regulary filter data updated import from website and past into another sheet

sometimes few sometimes a lot.

When a lot he overwrite other data that is below so I would like that the results being paste in the new sheet is limited to 50

paste Range (A1: D50) didn' work

and a second problem, if there are no results he paste all ! even I have
If Selection.Range("F").SpecialCells(xlCellTypeVisible).Count > 1 Then
I solved this temporary with putting a fixed row with values that he always filter 1 but ...

THanks foryour help !
Chris