printout macro issue

Can anyone tell my why this macro won't run? Debugging takes me to "Selection.Printout" but I have no idea what the problem is.

Please Login or Register  to view this content.

Worked fine with Excel 2003 (obviously without ", IgnorePrintAreas:=False").

The easiest way that I personally have found to do something similar to what I think you want (printing a selected area of a worksheet) is to use "Record Macro" button under the "Developers" tab. OR you could try the following, it worked for me after using the record macro, I just tweaked it using the information you had already in the coding you provided

Please Login or Register  to view this content.