Thread: copying the column of the active cell to another column
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default copying the column of the active cell to another column
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




Reply With QuoteReply With Quote