Reduce Macro Time

[aftabn10]

I have created a macro to remove BlankRows and BlankColumns from a spreadsheet that consist of data until row 65500. The macro works quite well but the issue I am having how i can increase the speed as I started running this macro an hour ago and it still hasnt completed. Is their anyway I can quicken this process?

The following is my code:

Please Login or Register  to view this content.

[Leith Ross]

Hello aftabn10,

This macro should speed things up for you. It will delete all the empty rows and columns in your data.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[aftabn10]

Thanks Leith Ross, ill give that a go.