How can i use Ctrl-F function of excel in macro

Hi

I need to count the occurances of "N" in the cells of my worksheet.

How can i do this?

Can i use Ctrl-F n do this?

Pls help

Regards,
Shwetha

Here is a way

Sub FindN()
Dim iVal As Integer
iVal = Application.WorksheetFunction.CountIf(Range("A1:L100"), "N")
MsgBox ("Number of N's on this sheet:" & " " & iVal)
End Sub