Learning How to Use Coded Functions

[Ark68]

I am trying to learn how to use Excel functions with VB code.

I am getting a "Compile error: Sub or Function not defined" with the following ....

I assign the variable.

Dim iFCCdel As Integer

I assign the function to the variable.

iFCCdel = CountIf("A:A", "C")

- Count all instances of "C" in column A
And use the value calculated.

MsgBox = ("CLASS C RECORDS:" & iFCCdel)

Obviously I'm missing something.

Jenn

 

[VoG]

try

iFCCdel = WorksheetFunction.CountIf(Columns("A"), "C")

 

[Ark68]

Hmmm ... got rid of one error, but led to another. LOL
"Compile Error: Function call on left-hand side of assignment must return Varient or Object."

Code stopped on

MsgBox = ("CLASS C RECORDS:" & iFCCdel)

 

[VoG]

Sorry, I didn't spot that one:

MsgBox "CLASS C RECORDS: " & iFCCdel