Cut and paste multiple cells in Excel
In article , "Don Guillett" wrote:
Try this macro where col a is 1
Sub cutnoncontingent()
For i = 1 To 10 Step 2
Cells(i,1).Cut Cells(i,2i)
Next i
End Sub
"cyndi" wrote in message
...
Hello,
I using Excel 2003, I want to be able to select cells a2,a4,a6,a8,a10 and
so
on, and paste them in b2,b4, b6,b8 and so on, when I cut them I get a
messages saying "The command you choose can't not be performed with
multiple
selections". I know at one point someone had shown me away around this,
is
this possible.
I think that you could do this with a 'helper' column ... say in column c.
1
2
1
2
... etc
Then turn on autofilter, select 2, copy and paste.
HTH
|