Nelson78
Well-known Member
- Joined
- Sep 11, 2017
- Messages
- 526
- Office Version
- 2007
Hello everybody.
I've the following operation:
The problem is the variable
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.
I've the following operation:
VBA Code:
result = Application.WorksheetFunction.SumIf(Sheets(1).Columns(1), title, Sheets(1).Columns(2))
The problem is the variable
VBA Code:
title
I think this should be the reason for the sum failure (result always 0).
How can I figure it out?
Thank's in advance.