Delete blank column & Row in selection

[shaileshgavanang]

Hi,

I am using software where i am exporting some report to excel.
after exporting to excel, i am getting lot of rows & column blank which is i am manualy deleting.

I need macro to delete blank column & row from selected range.

Thank you,

[Jakobshavn]

Select the range of interest and run this msall macro:

Please Login or Register  to view this content.

[shaileshgavanang]

Hi jakobshavn,

Thanks for code its working fine, thank very much for your time.

Thank you,