Cells(xlCellTypeVisible).Copy _
> Destination:=Range("F4")
> ActiveSheet.Range("$A$1:$E$279").AutoFilter Field:=1
> End Sub
>
>
> Cheers!!
>
> +
> *I did not do this for you. God is here working through me for you.*
>
> On Tue, Nov 4, 20
Trying to filter a few numbers from a larger group of numbers in one cell,
copy them, then paste them in another cell. Error comes up as "Runtime
error '1004': Paste special Method of Range class fail". When I go to
"debug", it shows this:
[image: copy to clipboard]
Sub Macro1()
'
' Macro1 Ma
