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

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

--
Regards
Frank Kabel
Frankfurt, Germany
"xnman" schrieb im Newsbeitrag
...
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

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

--

Vasant



"xnman" wrote in message
...
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