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?

Hi Marston,

Sub Tester()
Dim sStr As String
Dim pos As Long
sStr = "ABC DEF"
pos = InStr(sStr, " ")
MsgBox pos
End Sub

--

---
Regards,
Norman



" wrote in message
...
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?

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?