Worksheet.PrintedCommentPages Property (Excel)

Office 2013 and later

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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

expression .PrintedCommentPages

expression A variable that returns a Worksheet object.

Return Value


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.