count rows in a column for looping

[damorrison]

I was using this code

RwsCnt = ActiveSheet.UsedRange.Rows.Count
for i = 1 to RwsCnt

'Code

Next i

it works correctly but the value of the row count increases as the
macro goes along

how can I get this to count just the rows in column B?

 

[Gary''s Student]

For i = 1 To Cells(Rows.Count, 2).End(xlUp).Row

 

[damorrison]

For i = 1 To Cells(Rows.Count, 2).End(xlUp).Row

Great ,
thanks