Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting Cells that meet criteria across entire workbook
I am looking to write a macro that checks each cell in each sheet in workbook and counts the occurences of formulas. I am not sure how t approach this. The code below prints all the sheets in a workbook. It dimensions "s" as a Worksheet. Is it possible to use the sam thinking for what I want to do? That is, can you dimension a variabl as a cell (or range), check to see that it meets a condition, and kee adding this to a cumulative total that summarizes the result in message box? Sub PrintAll() Dim s As Worksheet For Each s In Worksheets() s.Select ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True Next s End Sub Thank -- ExcelMonke ----------------------------------------------------------------------- ExcelMonkey's Profile: http://www.excelforum.com/member.php...nfo&userid=522 View this thread: http://www.excelforum.com/showthread.php?threadid=26821 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting # of cells with that meet criteria in two columns | Excel Worksheet Functions | |||
Counting Consecutive Cells that meet Criteria | Excel Discussion (Misc queries) | |||
Counting lines that meet TWO criteria | Excel Worksheet Functions | |||
Counting cells that meet 2 differnet criteria | Excel Worksheet Functions | |||
Counting Values that meet another cells criteria | Excel Worksheet Functions |