range(range("A1"), range("A1").SpecialCells(xlLastCell))

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

no.reply7@comcast.net - 30 Nov 2006 18:08 GMT

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.

Reply to this Message

Karl E. Peterson - 30 Nov 2006 18:14 GMT

> I'm puzzled. I had a perfectly working code using
>
[quoted text clipped - 11 lines]
>
> Any thoughts?

First thought, cut/paste the actual problem code into a message, before
posting it to usenet. Impossible to diagnose syntax errors when you retype
the code. (Not that I myself would see it in this case, necessarily, but
neither I nor anyone else has a chance given what you've offered.)

Signature

Working without a .NET?
http://classicvb.org/

Reply to this Message

Rate this thread: