Hello,

I need to find out how many pages does a sheet contain
(can be 1 or 2 pages only), before sending the following
line: sheet.PrintPreview, ex

PageNum = sheet.Number_Of_Pages_To_Be_Printed
if PageNum = 1 then
sheet.PrintPreview
else
alert user
end if

This will print a 1 page list, if the number of items
exceeds the 1st page, the printing has to be cancelled

Thanks in advance!