Find Last Column with Data in Specific Row based on text

I'm trying to find the row that has "Net Due:" in it and then find the last column in that row with data (not the first empty row, as you could have empty rows and then data) and then highlight that range.

I got the below to work on a test sheet but has an error on the actual ones I need it on and I can't figure out why I'm getting the following error on 'LastCol =' row, Run-time error '91': Object variable or With block variable not set

I'm sure it's something silly but I've spent too long staring at it, thanks in advance!

Please Login or Register  to view this content.

Had to make a modification to the last row to get it to work how I wanted, but this is good, thank you!!!

Please Login or Register  to view this content.