Hi
yes you can. Your statement should work. Have you tried it?

--
Regards
Frank Kabel
Frankfurt, Germany

"Stefanie K." schrieb im Newsbeitrag
om...
I know that you can use * as a wildcard with sumif and countif
functions in excel worksheets, but I was wondering if it's also
possible in macros/vba.

For example:
Application.SumIf(Range(Cells(1, 32), Cells(433, 32)), "*.aa.1t",
Range(Cells(1, 17), Cells(433, 17)))

Is this possible? If not, alternatives to this would be greatly
appreciated.
Thanks,
Stefanie