View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Bruce Sinclair Bruce Sinclair is offline
external usenet poster
 
Posts: 169
Default 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