AutoFill

[keyser_Soze]

-Short-

How can I offset from myRange(1,offset) to myRange(1,offset+1)?

-Long-
I have copied inserted a column and would like to autofill row 1 in the
new column with the formula from the column to it's left. (.value does
not work since the fomula is based on the column)

Thanks.

 

[keyser_Soze]

Hmm, that short didn't look right. What I meant was
How can I AUTOFILL from myRange(...