N
no.reply7
I'm puzzled. I had a perfectly working code using
range(range("A1"), range("A1").SpecialCells(xlLastCell)).copy
and
range(range("A1"), range("A1").SpecialCells(xlLastCell)) .AutoFilter
Field:=2, Criteria1:="36084"
and all of a sudden, I get this error message:
Compile error: Wrong number of arguments or invalid property assignment
Any thoughts?
Thanks.
range(range("A1"), range("A1").SpecialCells(xlLastCell)).copy
and
range(range("A1"), range("A1").SpecialCells(xlLastCell)) .AutoFilter
Field:=2, Criteria1:="36084"
and all of a sudden, I get this error message:
Compile error: Wrong number of arguments or invalid property assignment
Any thoughts?
Thanks.