Thread: Selection
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Selection

Just a single column?

if selection.address = selection.cells(1).entirecolumn.address then
'whole column
else
'not whole column
end if



Bill wrote:

Hello,
How can I tell if an entire column has been selected or just a few cells in
the column?

Thanks,

Bill


--

Dave Peterson