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:
Sub Macro1()
'
' Macro1 Macro
' averages
'
' Keyboard Shortcut: Ctrl+m
'
Range("F4:F16").Select
Selection.ClearContents
ActiveSheet.Range("$A$1:$E$279").AutoFilter Field:=1, Criteria1:=RGB(198, _
239, 206), Operator:=xlFilterCellColor
Range("A8:A239").Select
Selection.Copy
ActiveSheet.Range("$A$1:$E$279").AutoFilter Field:=1
Range("F4:F15").Select
ActiveSheet.Paste
End Sub
How can I get my macro to cut and paste what I want without this error? The macro does EVERYTHING I asked of it, except paste. Thanks
Bookmarks