Run-Time Error '1004' AutoFill method of Range class Failed

**RS944** · 05-14-2013, 07:07 PM

Hey guys,

This is really weird and I don't know whats wrong.

I have been running this macro for a bit and worked fine. Then have just started giving me the error.

Any Ideas?

Please Login or Register  to view this content.

**jaslake** · 05-14-2013, 08:23 PM

Hi RS944

I'd suggest changing this line of Code

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Why??? Google "used range excel vba".

**AlphaFrog** · 05-14-2013, 08:27 PM

If a worksheet only had only two used rows, the Autofill could error. As an example, this code will cause the same Autofill error.

Please Login or Register  to view this content.

Try this...

Please Login or Register  to view this content.

**RS944** · 05-15-2013, 11:24 AM

Hey guys thanks for all the suggestions.

What I an trying to do is copy the formulas from cells O2, P2, Q2, R2 down to the next rows every time I add a new row. I have a macro that will run this macro every 15 minutes so just need some code that will copy from rows above. If there is a better code than what I having I am open to suggestions.

Also I am getting the error from the first Range line (when I debug it)

**AlphaFrog** · 05-15-2013, 11:30 AM

Did you try the suggestions and if yes, what happened?

**RS944** · 05-15-2013, 11:37 AM

Hey AlphaFrog,

Yes I did try the first one and still got same error but just retried yours and it worked.

....I had error when I just posted a minute ago. oops

But seems to be all good for now. thank you very much. yours seems to work like a charm.