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
 
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
 
Back
Top