Application.WorksheetFunction.SumIf and case sensitivity

[Nelson78]

Hello everybody.

I've the following operation:

result = Application.WorksheetFunction.SumIf(Sheets(1).Columns(1), title, Sheets(1).Columns(2))

The problem is the variable

title

the variable in the macro is in small letters, but in the criteria column is written in capital letters.

I think this should be the reason for the sum failure (result always 0).

How can I figure it out?

Thank's in advance.

 

[Nelson78]

Probably it's not the case sensitivity the problem.

 

[Joe4]

Hello everybody.

I've the following operation:

result = Application.WorksheetFunction.SumIf(Sheets(1).Columns(1), title, Sheets(1).Columns(2))

The problem is the variable

title

the variable in the macro is in small letters, but in the criteria column is written in capital letters.

I think this should be the reason for the sum failure (result always 0).

How can I figure it out?

Thank's in advance.

"Title" is a reserved word (already been used for something else in VBA). Reserved words are things like names of built-in functions, properties, objects, etc.
One easy well to tell is to create a simple macro where you use it, all entered in lower case, like this:

Sub Test()
    MsgBox title
End Sub

If Excel automatically capitalizes the first letter, like this:

Sub Test()
    MsgBox Title
End Sub

that usually indicates that it is a reserved word that in VBA.

You should NEVER use reserved words as the names of your variables, procedures, or functions in VBA. Doing so can cause errors and unexpected results.
Try changing your variable name to something like "myTitle".