View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ross Withey Ross Withey is offline
external usenet poster
 
Posts: 6
Default Instr function problem

Hello,
If cell A1 has the string value "Bananas"

Instr(1,"Range("A1"), "a") finds the first "a". My problem is, I want to
find the final "a".
Can you suggest the right code? I know I can increase the "1", but I need to
find the final "a" at the first attempt in a loop. Can you help please?
Thanks,
Ross