View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Meltad Meltad is offline
external usenet poster
 
Posts: 98
Default Select all rows except header row in one column

Hi Incidental,

Thanks for your reply, I used your code but it worked across all columns,
how do i specify for column N only?

Thanks, Mel



"Incidental" wrote:

Hi Mel

you could get the last row using .end something like

Dim i As Integer
i = [a1].End(xlDown).Row

will pass the number of the last row to the integer "i" then use in
your code

with activesheet
.rows("2:" & i).select
end with

hope this is of some help to you

S