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,


--