Autofill Macro

[ScabbyDog]

I have the following but it says Autofill method of range class failed. And then highlights the text below in red;

Please Login or Register  to view this content.

[ScabbyDog]

It's weird. Sometimes it works and sometimes it doesn't. Is there any way to improve the above coding? I'm just trying to drag down the formulas in cells A6, R6, W6, AA6 and AB6 all the way down to row 600 or so.

[AB33]

Both of these work for me

Please Login or Register  to view this content.

You omitted "DOT" from the second range