Home |
Search |
Today's Posts |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
dcount with vba
Hi,
Perhaps Application.DCount(...) without WorkSheetFunction... -- JRod Microsoft [MVP] - Excel http://EXCELer.blogspot.com ______________________________________ "J Slavin" escreveu na mensagem ... is it possible to use the dcount function with vba? i tried Application.WorksheetFunction.DCount(....) but didnt work, sayid it could not get the DCount function. thanks in advance, -- |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
dcount with vba
According to vba help, yes. You probably did not use proper syntax for the
ranges instead of a1:a32 use range("a1:a32") -- Don Guillett SalesAid Software "J Slavin" wrote in message ... is it possible to use the dcount function with vba? i tried Application.WorksheetFunction.DCount(....) but didnt work, sayid it could not get the DCount function. thanks in advance, -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DCount?? not working. Pls help | Excel Discussion (Misc queries) | |||
Using ADD function within DCOUNT criteria | Excel Discussion (Misc queries) | |||
DCount, with mixed type data | Excel Discussion (Misc queries) | |||
DCOUNT in Excel | Excel Worksheet Functions | |||
DSUM and DCount when criteria values are similar | Excel Worksheet Functions |