AutoFilter Copy with Destination Paste Options

[kc_native]

I am using the following code in a procedure which is accomplishing what I need, but I was wondering if when the AutoFilter pastes the visible rows to another destination (In a tab I call Clipboard), it paste values. Is there a way to modify the code to make the paste special, with formulas? I have tried adding the standard ".PasteSpecial Paste:=xlPasteFormulas" after Range("A1"), but it blows up the code.

With ActiveSheet.Range(Cells(1, 1), Cells(Cells(Rows.Count, 1).End(xlUp).Row, LastCol + 1))
        .AutoFilter Field:=2, Criteria1:=StoredArrayString, Operator:=xlFilterValues
        .SpecialCells(xlCellTypeVisible).Copy Destination:=Sheets("Clip Board").Range("A1")
End With

Thanks for any help or education you can lend me.

 

[Dryver14]

I don't know if it will help with the pasting but you do not need to use

.SpecialCells(xlCellTypeVisible).Copy

You can just .copy with autofilter

 

[kc_native]

I don't know if it will help with the pasting but you do not need to use

.SpecialCells(xlCellTypeVisible).Copy

You can just .copy with autofilter

I thought that .SpecialCells(xlCellTypeVisible) was necessary to copy just the filtered rows and not all rows in the data set.

 

[Dryver14]

I do think you need it with advanced filter but not if you just autofilter