have text in rows 61 and 62 and i want the lastrow before that (45). i know
i can start at the top and go down, but i want to do this.

anyway

sLastRow = .Cells(Rows.Count, "B").End(xlUp).Row ' gives me 62
sLastRow = .Cells(Rows.Count, "B").End(xlUp)(3).Row 'gives me 64
sLastRow = .Cells(Rows.Count, "B").End(xlUp).End(xlUp).End(xlUp).Row
'gives me 45, which is what i want

why doesn't the 2nd one work?
--


Gary