VBA Format Multiple Ranges & LastRow

Hi, I wonder whether someone may be able to help me please.

I'm trying to put together a very small script which applied formatting to muliple ranges from the 'StartRow' to the 'LastRow'.

The code below is what I've put together so far, but I receive a error when running this.

Please Login or Register  to view this content.

I know that the issue is this line

Please Login or Register  to view this content.

but I'm not too sure how to get around it.

I just wondered whether someone may be able to look at this please and let me know where I'm going wrong.

Many thanks and kind regards

Please Login or Register  to view this content.

I think that you need

Please Login or Register  to view this content.

Hi @yudlugar and @hudibyk, thank you both for taking the time to reply to my post and for the solution.

I didn't realise it would be that simple.

All the best and kind regards