VB Code to cleanup Wrap Text

Hello:

Please refer to attached file.
I get this format Daily CLoseout report with Wrap Text and Merge & Center.
I need VB Code to clean up the file by deleting all blank columns and blank rows so that it becomes like normal
data.

Let me know if you have any questions.
Thanks.

Riz

Please Login or Register  to view this content.

Kind regards
Leo

Hello LeoTaxi:

Please refer to attached file.

Great work....now next step would be delete blank columns (Start with column 50 and go left) and blank row.
Once this is done, have Column Height and Column Width Adjusted.

Let me know if you have any questions.
Thanks.
Riz

after run the code there is no blank row or column


Kind regards
Leo

Hello LeoTaxi:

You are correct....
I need to modify the data, I will let you know how i need it.

Thanks a lot for great help

Riz

This should delete empty columns from 50 to 1, if it helps

Please Login or Register  to view this content.