View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Selecting an entire column

Sub dural()
ActiveCell.EntireColumn.Select
End Sub

--
Gary''s Student - gsnu200716


"Marco" wrote:

I'm trying to write a code that selects the entire column, regardless of what
cell I'm in. I run a find and sometimes end up in column O or it could be AA
or X. I want to be able to select that particular column.

I know that Range(A:A).Select will select column A. Column(2).Select will
select column B.

Thanks in advance for your help.

Marco