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


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Paul James" wrote in message news:hPo%b.62463$Xp.307476@attbi_s54...
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