Counting blanks in a string

[xnman]

In VBA, I know there is a simple way of counting blanks in a string, but
I can't remember it. Anyone know how to do this?

thanks
xnman

 

[Frank Kabel]

Hi
one way:
len(your_str)-len(replace(your_str," ",""))

 

[Vasant Nanavati]

Len(MyString)-Len(WorksheetFunction.Substitute(MyString," ",""))