r1c1 and autofill horizontal.. please help

[KATIEexcel]

Hello.
In sheet "QC" cells b4 to b27, i want the formulae
=AVERAGE(DO!R2C[1]:R10000C[1])
=AVERAGE(DO!R2C[2]:R10000C[2])
=AVERAGE(DO!R2C[3]:R10000C[3])
=AVERAGE(DO!R2C[4]:R10000C[4])
=AVERAGE(DO!R2C[5]:R10000C[5])
I.E. sheet "QC" cells b4 to b27 refer to the averages of rows for columns 3-26 (c-z) on sheet "DO"

When I can do this I will use similar formulae for standard deviations, min, max, ect in columns c,d,e...


This is my code so far:

Please Login or Register  to view this content.

I need the c[1] to increase with each row on autofill.
Is this possible?
I could do it with a loop, but i can't refer to "x" in a formula, can i? [dim x as integer, for x = 1 to.. next x]

Can anyone help?

Moderator's Edit: Use code tags when posting code. To do so in future, select your code and click on the # icon at the top of your post window.

[KATIEexcel]

perhaps I could use the indirect function?

[arlu1201]

Can you explain with the help of a sample excel file?

[KATIEexcel]

Here you go thanks

[arlu1201]

Try this -

Please Login or Register  to view this content.