Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
What's wrong with this
I'm trying to count the number of times a cell has a font size of 22, and it
is giving me zero. I'm new to this stuff would appreciate any help. Function countbyfont(InRange As Range, _ Whatfont As Integer, _ Optional ofText As Boolean = False) As Long Dim Rng As Range Application.Volatile (True) For Each Rng In InRange.Cells If Cells.Font.Size = Whatfont Then countbyfont = countbyfont + 1 End If Next Rng End Function |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert Calculated Field (wrong Qty*Price = wrong Amount) | Excel Discussion (Misc queries) | |||
i did something wrong | Excel Discussion (Misc queries) | |||
Min Max What's Wrong? | Excel Worksheet Functions | |||
Getting wrong value due to ref? | Excel Discussion (Misc queries) | |||
where does it go wrong? | Excel Programming |