Runtime error 1004 in VBA with AutoFill

Hi,

This is actually my first post to the forums, also pretty much making my first cuts in VBA so bear with me please

Using Excel 2010;

I'm editing two worksheets in a multisheet workbook, transfering data from "Sheet2" to "Sheet1" using copy-paste.
I have an unknown amount of data in a list with headers in columns A-J in Sheet2, which I will need to copypaste to Sheet1.

I will then add formulas to columns H and J, starting from row 4, the first row below headers. I will then need to autofill the formulas to the last row.

Amount of rows can be different everytime and can change between 1-221 at the moment.

I get Runtime error 1004 at lines with autofill. Otherwise code runs fine. RT error is my major obstacle, but I don't mind suggestions about optimising code as I'm a new hand in VBA

Please Login or Register  to view this content.

Help much appreciated!

Br, Arkki

Originally Posted by Norie

Does this work for the first AutoFill?

Please Login or Register  to view this content.

Hi,

for some reason it does not enter the formula at all.

In reference to previous post by Norie, the problem is not entering the formula to the range. The issue is that it should autofilled only to the last row with data.

That last row is usually row 220, but can be anything between row 4-220. End users don't want the autofill by default to whole max range.

Right now the code works fine otherwise. But users dont want to fill down the formula by themselves, it should come from the macro.

Many thanks,

Arkki

Hi here's the sample workbook, code is stored in ThisWorkBook.

Br,

Arkki