On Sheet1 I and Row106 I have 50+ columns of calculation results that I want
copied to Sheet2, Column 4 over the equivalent number of rows.

=OFFSET('Recipe Calculation'!$D$106,COLUMN()-4,0)

....the result of Sheet1, Row106 and Column4 is dead on, but when I want to
copy the above function to the other cells of Column4 on Sheet2, the result
is always the same as on the first cell. What am I doing wrong?

I can't get my head around this and the Excel Help file is not much better
than the Excel book I have. Please help.

Thanks in advance...Carlos