Extract text using LEFT/FIND but with VBA

[Thebatfink]

Hi,

I'm currently using the formula below to extract partial strings from cell contents for example,

=LEFT(J11,FIND("*",J11,1)-1)

I'd like to do this with VBA however. I have tried,

Application.WorksheetFunction.Left(myString, _
Application.WorksheetFunction.Find("*", myString, 1) - 1)

but it didn't like it. I presume this is possible, but what is the correct way of doing this?

Thanks!
Batfink

 

[Thebatfink]

Thanks for the help, works well