Even when i use the line continuation, or all on one line, it stil
gives me that Autofilter method range class error.

This thing is unbelievable.

i've no idea what's wrong with it

--
Message posted from http://www.ExcelForum.com

is the sheet protected?

If you enter ListPGE in the name box and hit enter (ListPGE should be
selected) can you then do Data=filter=Autofilter and select an account
number in the first dropdown.

It has to be something particular to your environment. Applying an
autofilter really isn't that hard (any merged cells or anything else
unusual)?

--
Regards,
Tom Ogilvy

Jmbostock wrote in message
...
Even when i use the line continuation, or all on one line, it still
gives me that Autofilter method range class error.

This thing is unbelievable.

i've no idea what's wrong with it.


---
Message posted from http://www.ExcelForum.com/

Thanks for everyones help, but i'm calling it quits on this particular
project.

I think the problem is related to something in the sheets, rather than
something i've written.

I'm going to start from scratch and hope for the best.

Again, you guys are awesome.

James


---
Message posted from http://www.ExcelForum.com/