I want to loop through each row, doing verious things, and
I need to stop at the last active row. I never know
exactly how many rows are active.

What VB reference do I use to get that number:

For i = 1 to ??????
Do Stuff
next i