View Single Post
  #4   Report Post  
Biff
 
Posts: n/a
Default

Hi!


If Mid(string1, l, 1) = Mid(string2, l, 1) Then Matchdigits =
Matchdigits & Mid(string1, l, 1)


This UDF works but the problem is line wrap. The above code needs to be all
on one line or use the line continuation character: _ (underscore)

If Mid(string1, l, 1) = Mid(string2, l, 1) Then Matchdigits = _
Matchdigits & Mid(string1, l, 1)

Biff

"toyota58" wrote in message
oups.com...
Sorry...I'm a newbie. Am I doing the right thing ? I went to TOOLS
MAKRO VB Editor (ALT + F11) Insert module...copy and paste ...all
I get is Syntax error...


If Mid(string1, l, 1) = Mid(string2, l, 1) Then Matchdigits =
Matchdigits & Mid(string1, l, 1)


.