Hi all

Is there a way to paste along side any text etc, cells that are to the left.

If I have text or anything in A1 to A20
could be A1 to A17 or T1 to T20

IF B1 or U1 is highlighted is there a way that what I have copied, paste it
to
B1 to B20 or B1 to B17 or U1 to U20.

Thanks in Advance