FIND funtion VBA Equivalent

[mmf]

Hi
Does anybody knows which is the Find(findtext,withintext,startnumb) in VBA?
Regards
MMF

[royUK]

Have a look at the VBBA help files for Find.

[sweep]

I think it's InStr you're after

InStr( [start], string_being_searched, string2, [compare] )

start is optional. It is the starting position for the search. If this parameter is omitted, the search will begin at position 1.

string_being_searched is the string that will be searched.

string2 is the string to search for.

compare is optional. This is the type of comparison to perform.

[mmf]

Cheers Sweep that worked perfect
Best Regars
MMF