07-22-2010, 08:39 AM
I understand it is solved. Just curious to know, If your text string was so,
txtstrng = "this is codeigo 86 testing numeric"
I would simply do this,
Why run unnecessary loops ?
Food for thought mate...
txtstrng = "this is codeigo 86 testing numeric"
I would simply do this,
Code:
reqnum = Split(Split(txtstrng,"codeigo")(1),"testing")(0)
msgbox reqnum
Why run unnecessary loops ?
Food for thought mate...
Basanth
Give a fish to a man and you feed him for a day..Teach a man how to fish and you feed him for life.
Give a fish to a man and you feed him for a day..Teach a man how to fish and you feed him for life.