ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] Excel §PÂ_¦rÅéÃC¦â¦@¦³¥X²{´X¦¸

Function GetFontCount(xArea As Range, xA As Range)
Dim xR As Range
For Each xR In xArea
    If xR = xA And xR.Font.ColorIndex = xA.Font.ColorIndex Then
       GetFontCount = GetFontCount + 1
    End If
Next
End Function

Xl0000063.rar (11.26 KB)

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡µLªk¾B¾×¡j©È®É¶¡®ø³u¡Aªá¤F³\¦h¤ß¦å¡A·QºÉ¦U¦¡¤èªk­n¾B¾×®É¶¡¡Aµ²ªG¬O¡G®ö¶O¤F§ó¦h®É¶¡¡A¥B¤@µL©Ò¦¨¡I
ªð¦^¦Cªí ¤W¤@¥DÃD