View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Myrna Larson Myrna Larson is offline
external usenet poster
 
Posts: 863
Default Finding a particular character in a string using VBA


Application.Find is the VBA equivalent of going to the Edit menu and selecting
Find. As Norman says, you use Instr for the equivalent of the worksheet
function FIND.

On 13 Sep 2004 17:41:33 -0700, "
wrote:

As it reads in the heading...

I tried to use Application.Find but that doesn't seem to be available.

I need to find the location of the first space in a character string.
Is there any easy way to do this?