Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extra Row in Defined Print Area | Excel Discussion (Misc queries) | |||
Clicking Cell Link Changes Cell on Another Sheet | Excel Discussion (Misc queries) | |||
Print multiple excel charts within one sheet to fit to a page lik. | Excel Discussion (Misc queries) | |||
In Excel, how do I make the freezed pane area, print on each page. | Excel Discussion (Misc queries) | |||
Printing - Have to set print area 1 column further than necessary | Excel Discussion (Misc queries) |