Looping through tables in vba, igrnore empty tables?

Hi all,

So I have this following code (piece):

Please Login or Register  to view this content.

Which was working perfectly until I had 5 tables and the last one was the "BLANKTable" but I had to add a new table, to which the interior colour change should apply.. but if the BLANKTable is empty then the code throws an error. (and I realized other tables may end up empty as well before this step, so this code piece is really not right)

I can see why.. but I don't know how to loop through all the tables except for the ones that's databody range is empty.. which is what I would need here I think. Could someone help with this?

Question posted on Mr.Excel Message board as well, link: https://www.mrexcel.com/forum/excel-...ml#post5276662