Do until last row

I've been trying to work out how to format cells until the last cell that has data in and then stop. I have written the code for the formatting but just need some help with making it run until the last cell with a value in it. I would prefer it in this format.

Please Login or Register  to view this content.

The column, if needed, is BA.
Thanks

I really needed it to loop as i have many if statments specific to the cell being formatted within the loop.
I've managed to do it myself though.

Please Login or Register  to view this content.