more-arw search

Q&A Forum

How to use Wild characters (*) symbol in countifs in vba

sai ram's Profile

Hi All,

I'm trying to use (*) symbol in 'countifs' function in vba. But, i'm getting error for below.

Range("c2").FormulaLocal = "=countif(" & Range("b2:b7").Address() & "," & Range("b2").Address(rowabsolute:=False) & "," & Range("a2:a7").Address() & "," & "*cms*" & ")"

Could you please suggest me, how to use (*) symbol in above formula.

Answers

Topic Expert
Wayne Spivak
Title: President & CFO
Company: SBAConsulting.com
LinkedIn Profile
(President & CFO, SBAConsulting.com) |

Sai,

There are better places than here for this type of question (since it is really programming), however a simple Google search yielded this (among a whole bunch more):

http://www.mrexcel.com/forum/excel-questions/493619-using-wildcard-*-visual-basic-applications-excel.html

350 views

Get Free Membership

By signing up, you will receive emails from Proformative regarding Proformative programs, events, community news and activity. You can withdraw your consent at any time. Contact Us.

Business Exchange

Browse the Business Exchange to find information, resources and peer reviews to help you select the right solution for your business.

Learn more

Contribute to Community

If you’re interested in learning more about contributing to your Proformative community, we have many ways for you to get involved. Please email content@proformative.com to learn more about becoming a speaker or contributing to the blogs/Q&A Forum.