Count Number of CF Q

[Seanie]

Would it be posssible to Count the number of CF instances in each
sheet and display results in a message box?

eg

Sheet1 = 5
Sheet2 = 10
Sheet3 = 7
etc etc

 

[Jim Cone]

The free Formats & Styles add-in counts CF conditions in the entire workbook and displays a cell count...
http://excelusergroup.org/media/
--
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware



"Seanie" <[email protected]>
wrote in message
Would it be posssible to Count the number of CF instances in each
sheet and display results in a message box?
eg

Sheet1 = 5
Sheet2 = 10
Sheet3 = 7
etc etc

 

[Seanie]

many thanks Jim, exactly what I was after

 

[Jim Cone]

You are welcome. Glad to get the feedback.
'--
Jim Cone




"Seanie" <[email protected]>
wrote in message

many thanks Jim, exactly what I was after