I would like to:

Paste a variable number of contiguous cells that have been copied from
a different worksheet.
After pasting the cells I would like to select the cells in column to
the right of what was pasted. For example if I have just pasted five
cells, I would like the five cells to the right of those cells
selected. If I just pasted two cells, I would like to select the two
cells to the right.
(I will then do some formatting on those cells once selected but
although a newbie, I think I can handle that :)
)

Help appreciated,
~Vic