Thread: Active cell counting in particular print page (one sheet having different print area)
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
antoka05
 
Posts: n/a
Default Active cell counting in particular print page (one sheet having different print area)

you can do so:
cellNumber = range(ActiveSheet.PageSetup.PrintArea).Cells.Count

or, for a particular sheet, you can do so:
cellNumber = range(sheets("Index1").PageSetup.PrintArea).Cells. Count
and so you will have the number of cells in the print area of the
sheets 'Index1'


--
antoka05
------------------------------------------------------------------------
antoka05's Profile: http://www.excelforum.com/member.php...o&userid=29024
View this thread: http://www.excelforum.com/showthread...hreadid=487865

Reply With QuoteReply With Quote