Deleoing unused rows &columns(formatting ,color etc ) therein for all worksheet in wkbook

Dear Experts ,


Firstly i must admit that this forum is making me feel so much happy and i must admit that i have had the good fortune of experts taking precious time to help me ,so i take a moment to thank all of them before i proceed to explain my new project !

Like the title suggest's ,i have a output file in which i see that the formatting gets applied even across unused range as well -Both rows and columns -please see attachment !

If you closely see the attached workbook ,in the tabs(worksheets of this workbook) ,the used rows in each worksheet are not always the same ,

For example in some tabs (worksheets ), i have 3 rows ,in some i have 7 rows ......

Similarly in each of the tabs (worksheets ) i have 5 columns filled ,in some i have 6 ......

Is there a macro which can go through each of the wks and delete all the blank rows and columns and the formatting (color's ,boundaries etc )therein !

Any help will be much appreciated ,

Humble Regards ,


Amlan Dutta