To select the entire column whenever the user selects a cell, put this
in the worksheets code (i.e. right-click on the sheet's tab in XL and
select View Code)

private sub worksheet_selectionchange(byval target as excel.range)
activecell.entirecolumn.select
end sub


Col


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