VBA: Remove vertical borders if cell is blank

I have been trying to piece together some script to remove vertical borders for a row if there is no data in the first column for that row. Following is the script I have so far:

Please Login or Register  to view this content.

Any help in resolving would be appreciated.

Thanks,

Met

Maybe what you call empty is not empty but again as we can't guess without any attachment neither some details …

How about

Please Login or Register  to view this content.

Hmm.. Still no luck. I have attached a sample spreadsheet with expectations.

Thanks,

Met

Maybe

Please Login or Register  to view this content.

If that doesn't work, please supply a workbook that includes your code.

That did it.

Thanks,
Met

Originally Posted by Fluff13

Maybe

Please Login or Register  to view this content.

If that doesn't work, please supply a workbook that includes your code.

If I am not mistaken, you can do this without using a loop...

Please Login or Register  to view this content.

Originally Posted by Metrazal

That did it.

Thanks,
Met

You're welcome & thanks for the feedback