Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.vb.general.discussion

[email protected][_2_] no.reply7@comcast.net[_2_] is offline

external usenet poster

Posts: 6

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

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 With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
use variable in Workbooks("book1").Worksheets("sheet1").Range("a1"	Luc[_3_]	Excel Programming	2	September 28th 05 08:37 PM
"Subscript out of range" error for: Workbooks("Test1.xls").Save	Just12341234	Excel Programming	2	June 17th 05 03:16 PM
Using "Cells" to write "Range("A:A,H:H").Select"	Trip Ives[_2_]	Excel Programming	3	June 5th 04 03:13 PM
XP VBA: Range("A2", ActiveCell.SpecialCells(xlLastCell)).Select	wessman	Excel Programming	2	July 23rd 03 06:33 PM

All times are GMT +1. The time now is 04:40 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us