ProgressBar

Hello.
I have created a macro int excel 2007. Now i want to insert a progressbar in this without the userform... I have already used Application.CursourType = XlWait........But it;s not as good as it shows like Sytem is in Hang Postition....

Please Tell me what to do in this condition.

You can add a message to the statusbar.

Also, see if you can speed up the code by removing unnecessary selecting & activating.