Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
countif usage in macro
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
countif usage in macro
Dim myRng as range
dim nResult as long set myrng = worksheets("sheet1").range("e2:E12") nresult = application.countif(myrng,"europe") parthaemail wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search, Copy, Paste Macro in Excel | Excel Worksheet Functions | |||
Closing File Error | Excel Discussion (Misc queries) | |||
macro with F9 | Excel Discussion (Misc queries) | |||
Make Alignment options under format cells available as shortcut | Excel Discussion (Misc queries) | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) |