Show the code.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"phil2006" wrote in
message ...

I am getting a message saying 'autofill method of range class failed'
when I run my macros. Is there any way to remedy this? I have about
9000 rows of data.

Cheers


Phil


--
phil2006
------------------------------------------------------------------------
phil2006's Profile:
http://www.excelforum.com/member.php...o&userid=35092
View this thread: http://www.excelforum.com/showthread...hreadid=556389