Worksheet.PrintedCommentPages Property (Excel)

Returns the number of comment pages that will be printed for the current worksheet. Read-only

Version Added: Excel 2010

expression .PrintedCommentPages

expression A variable that returns a Worksheet object.

Return Value

Long

The PrintedCommentPages property will only return a number greater than zero if the Comments setting on the Sheet tab of the Page Setup dialog box is set to At end of sheet. This property will return zero if the sheet is a Chart sheet or a MS Excel 5.0 Dialog sheet.

Show: