You are welcome, many thanks for the rep. point.
Macro performance is slow when page breaks are visible in Excel, as stated by Microsoft here :
http://support.microsoft.com/kb/199505
So, after you print / print preview, you should "hide" the page breaks :
1. Manually :
Click the Microsoft Office Button, and then click Excel Options
Click the Advanced category, and then click to clear the Show page breaks check box under the Display options for this worksheet section
2. Or by using macro like this :
Then run your macro, it should be much faster now.
Regards
Bookmarks