copying the column of the active cell to another column

  • Thread starter Thread starter Paul James
  • Start date Start date
P

Paul James

I would like to have VBA copy the entire column of the Activecell to another
column I specify, say Column J. How can I do this?

Thanks in advance.

Paul
 
Hi Paul

Sub test()
Columns(ActiveCell.Column).Copy Columns("J")
End Sub
 
Your code "Columns(ActiveCell.Column).Copy Columns("J")" works great.

Thanks, Ron.

I was trying things like "Activecell.columns.copy" but of course that didn't
work.

Paul
 
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

InputBox for column letter problem 2
Copy Active Range from one workbook to another 1
Autofill Based on a Changing Column 2
Copying a formula to a range 2
Combine three InputBoxes into one? 7
comparing two columns in vba 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Copy columns and paste with blank column between 5

Back
Top