=a1*INDIRECT("Sheet2!"&ADDRESS(ROW(A1),COLUMN(A1)) )

--
Regards,
Tom Ogilvy


"John Uebersax" wrote:

Thanks Bob and Tom.

This seems to work for copying cells within the same column (which I
recognize was how I posed the question).

But what about also copying the formula

=A1*INDIRECT("Sheet2!a1")

to the next column, or to a 10x10 block of cells?

--
John