Counting chars in a string

B

bcmiller

Hi,

I am writing some code to insert new records into an excel databas
where a key value has muliple values in the one record.

The separator is a comma.

Is there a way to count the number of comma's in a given string withou
having to write a new function???

Cheers,

b
 
B

bcmiller

Thanks Yogendra,

I had written a for loop to do the job, but that was slowing my macr
down, your tip has cut the size of my code and its execution time.

Cheers,

B
 
Top