dcount with vba

J

J Slavin

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,
[email protected]

--
 
H

Harlan Grove

J Slavin wrote...
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.
Click to expand...

It works for me.

That's the message Excel displays when there are errors in the function
call. What's you *EXACT* VBA statement calling DCount?
 
D

Don Guillett

According to vba help, yes. You probably did not use proper syntax for the
ranges
instead of a1:a32
use
range("a1:a32")
 
Top