Hi everyone.

I'm trying to take this equation:

Sheets("Sheet1").Activate
Count = Range("C4")
Sheets("Sheet2").Activate
Range("C4") = Range("C4") + Count
Sheets("Sheet1").Activate
Range("C4").ClearContents
And AutoFill cells C4 through C42 on Sheet2 in the same way.

When I try to use an Autofill command, it just fills them all in with the same numerical value as Sheet2C4.

Thanks for any help.