Highlight the empty cells

Hi,

I would like to highlight the empty cells (Column A to Column H) with data entry in the rows.

Could you please advise how should I set the range to the last row with data in it?
Like search for the last row of entry, include it in the range and highlight the empty cells up till that row...

Here's my code:

Please Login or Register  to view this content.

Many thanks!

hello finding the last used cell

Range("A65536").End(xlup).Select


you can add this and use as reference