View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
navin navin is offline
external usenet poster
 
Posts: 32
Default Search array for string

Hi all,

Is there a function in vba to search occurrence of a letter and return
its index?
I need to find the first and nth index of a character in an array.

Array: (****+++++++**)

I need to find out the first occurrence of + and last occurrence of +
in the array. I got the result by looping thru the array but was
hoping
to find out a smaller function to achieve this.

Thanks for the help.

Navin