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


--
parthaemail
------------------------------------------------------------------------
parthaemail's Profile: http://www.excelforum.com/member.php...o&userid=31311
View this thread: http://www.excelforum.com/showthread...hreadid=510077