"DrB" wrote...
That works. Thanks to everyone.

Now I want to paste into cells but keep B2 the same and allow A to
change as I paste along the row. I tried =indirect(A&"B2") but did
not work. Can it be done?
....

Your formula =INDIRECT(A&"B2") doesn't work unless A is a defined name
that evaluates to a text string, perhaps to "XYZ", in which case
A&"B2" would evaluate to "XYZB2", and that'd have to be a different
defined name referring to a cell range.

If you want the column letter to vary along the row given by the value
of cell B2, then you need to use something like either

=INDEX($1:$65536,$B$2,x)

or

=INDIRECT("R"&$B$2&"C"&x,0)

where x is a placeholder for an expression that determines how you
want the column to vary.