dcount with vba
 

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,


--

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,


--

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,


--