What is wrong in this Sub?

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

Hi everyone,

I am getting an error in this:

Sub MoveCells()
Columns("b:b").Select
Selection.Cut
Columns("g:g").Select
Current.Selection
Selection.Paste 'Here I am getting the error
End Sub

Anything wrong with "Paste"?

Thanks,
Mike
 
Hi
try
Sub MoveCells()
Columns("b:b").cut Destination:=Columns("g:g")
end sub
 
Sub MoveCells()
Columns("b:b").Cut Destination:=Columns("G:G")
End Sub

worked for me.
 

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


Back
Top