As cool as it looks watching your macro manipulate the screen, you can help it run faster if you turn off Screen Updating.
1. At the beginning of your code put this line:
Application.ScreenUpdating = False
2. At the end of your code put this line:
Application.ScreenUpdating = True
October 24th, 2008 at 5:42 pm
[...] following macro will remove blank rows without any sorting (turn off screen updating to go [...]