Select through last non blank row in a column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to get a range from b18 down to the last cell in the column - I thought this would do it based on my recording of a macro but I end up with b1:b65535 - any suggestions

Range("B18", "B65535").Selec
Range(selection, selection.End(xlUp)).Selec

Also I presume I can prefix the ranges with a worksheets object correct

May the worksheet be hidden during the selection

Thanks as usual.
 
ERic,

Try

Range("B18",Cells(Rows.Count,"B").End(xlUp)).Select

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

eric said:
I am trying to get a range from b18 down to the last cell in the column -
Click to expand...
I thought this would do it based on my recording of a macro but I end up
with b1:b65535 - any suggestions?
 
Back
Top