View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ardus Petus Ardus Petus is offline
external usenet poster
 
Posts: 718
Default selecting the currently active column

Activecell.EntireColumn.Select

HTH
--
AP

"armagan" a écrit
dans le message de news:
...

does anyone know how to do this in VBA?

when you have selected a cell, I want to select the whole column
(without manually specifying which one) of the currently active cell.

any help appreciated


--
armagan
------------------------------------------------------------------------
armagan's Profile:
http://www.excelforum.com/member.php...o&userid=34237
View this thread: http://www.excelforum.com/showthread...hreadid=545437