VBA : Hide Blank Rows

Dear all,

Need you help with correcting / simplifying macro to hide blank rows.

PFA for the sheet. Row 18 is not being hidden.

Please Login or Register  to view this content.

Request your help in correcting the code.

Thanks,
Vinod Krishna

Because your lastrow variable only considers cells with data in them your last row is row 16. Row 18 is not being considered in the loop. The quick fix is to increase LastRow by one or 2. Example:

Please Login or Register  to view this content.

Try to

Please Login or Register  to view this content.