countif usage in macro

[parthaemail]

if i give the function =countif(sheet1!E2:E12,"=Europe") in blank
shell of excel ,it gives no of rows having the word europe in the
column E . but if i give the same commend in macro it shows syntax
error .


Sub parthamacro()
'
' parthamacro Macro
' Macro recorded 2/8/2006 by 128304
'

'
Dim nResult As Long
nResult = sheet1.countif(sheet1!E2:E12,"=Europe")

End Sub


can you please help me , how to use countif function in macros

 

[Don Guillett]

You can help yourself by looking at the vba help index or answer for
worksheet functions.

--
Don Guillett
SalesAid Software
(e-mail address removed)
"parthaemail" <[email protected]>
wrote in message
news[email protected]...

 

[Dave Peterson]

Dim myRng as range
dim nResult as long
set myrng = worksheets("sheet1").range("e2:E12")
nresult = application.countif(myrng,"europe")