To delete blank columns and rows in a different sheet

[naveenhs5]

Hello

I have command button in Sheet 3 (from where I will be running the macro) and I need a macro which will delete all the blank columns and rows in the data containing in Sheet 1.


Thank you

[playaller]

Question? If the columns and rows are already blank then why delete them? Is it to revert the cell format back to general?

[naveenhs5]

I have a raw data which contains empty columns and rows And I need to delete them at one go and I should retain only col n rows which has data