Change the formula to

=Offset('Sheet2'!$E$22,Column(A1),0)

and then copy across.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jim May" wrote in message
news:A5xGd.30248$jn.20884@lakeread06...
On sheet1 cell F90 I have =Offset('Sheet2'!$E$22,1,0)

I'd like to copy F90 to G90:M90
whereby the row parameter in F90
will increase by 1 with each column
for example J90 would have in it:
the equivalent of:
=Offset('Sheet2'!$E$22,5,0)

How should I alter my F90 to accomplish?
TIA,