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

i have a excel sheel with different print pages separeted by print area
like


page1

page2

page3

like that

but i want to count the number of active cells on each print area
(page).

i know the function to count all acitves cells in a page (whole sheet)
application.counta(range(a:a))

expecting reply asap


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

Reply With QuoteReply With Quote