Hi D.S,

Try this .......

intJobCount = Application.WorksheetFunction.CountIf(Range("D:D") ,
strJobNumb)

Cheers
Nigel

"D.S." wrote in message
...
In my code, I'm trying to return a count of instances (intJobCount) a value
exists in worksheet column D. This value being set as variable strJobNumb.
The following code is preventing my code from even starting. The variable
strJobNumb will always be an alphameric beginning with a letter.

This line of code will stop me from running with a < Compile error: Expected
list separator or )
intJobCount = Application.WorksheetFunction.CountIf(D:D, strJobNumb)

If I add quotes to the columns such as below, it will not run, and I will
get a < Compile error: Type mismatch

intJobCount = Application.WorksheetFunction.CountIf("D:D", strJobNumb)

Any Ideas?

D.S.




----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---