Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pasting data and then selecting the cells next to what was pasted.
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pasting data and then selecting the cells next to what was pasted.
Sub tst()
range("A2:A5").Copy range("C3:C6") range("C3:C6").Offset(0, 1).Select End Sub "Vic" skrev: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pasting same data over many cells containing a formula | Excel Worksheet Functions | |||
Selecting last pasted object | Excel Programming | |||
Pasting on Filtered Data Sheets without pasting onto hidden cells | Excel Discussion (Misc queries) | |||
Selecting Cells With Sumproduct Formula, Then Pasting Its Value Over Top | Excel Programming | |||
Pasting all but Column widths doesnt get pasted. | Excel Discussion (Misc queries) |