Sub CountFormulas()
MsgBox ActiveCell.SpecialCells(xlCellTypeFormulas, 23).Count
End Sub
It works fine, but I have come to wonder if it is possible somehow to count
also conditional formatting formulas. I have looked in Visual Basic Help on
SpecialCells Method, but I can't make out what to do.
Regards
Hans Knudsen
David Hager
MVP - Microsoft Excel
Baton Rouge, La.
Hans Knudsen wrote in message <80ivla$aj0$1...@news.inet.tele.dk>...
Hans Knudsen wrote:
>
>
> Hello
> About a year ago I got an answer from John Walkenbach which included the
> following one-liner (thanks John if you are out there somewhere)
>
> Sub CountFormulas()
> MsgBox ActiveCell.SpecialCells(xlCellTypeFormulas, 23).Count
> End Sub
>
> It works fine, but I have come to wonder if it is possible somehow to
count
> also conditional formatting formulas. I have looked in Visual Basic Help
on
> SpecialCells Method, but I can't make out what to do.
>
> Regards
> Hans Knudsen
>
>
--
Posted via CNET Help.com
http://www.help.com/