Thread: How do I find a specific characters position in a string variable
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] paul@excelmastery.com is offline
external usenet poster
  
Posts: 2
Default How do I find a specific characters position in a string variable
Hi
I need to find the position of a particular character in a string variable
within a macro.

I can do this using the command =FIND(" ",B2) in an excel sheet to return
the position of the first space in the string in Cell B2.

What is the equivilent in VBA?

I am using Excel XP (2002)

Thanks
Paul

Reply With QuoteReply With Quote