Pasting data and then selecting the cells next to what was pasted.

  • Thread starter Thread starter Vic
  • Start date Start date
V

Vic

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
 
Sub tst()
range("A2:A5").Copy range("C3:C6")
range("C3:C6").Offset(0, 1).Select
End Sub


"Vic" skrev:
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create if partial match then copy and paste data from one cell to another 1
How to use OFFSET in VBA 1
Copy contents of a cell and paste it into text field 1
Excel Data pastes into 2 cells not 1 1
Copy text from cell and paste it in a separate text box (contents tobe linked) 7
paste linked cells show "0" 6
Paste to next row if cells are not empty 2
Copy excel cell to webform (search box) and press enter 10

Back
Top