VBA Code Modification

Hello there,
I have some code - originally kindly given to me from someone here a long time ago.
I need to modify it, I am not very good with VB and have been trying last 2 days without success.

Currently this code searches for text which begins with a < and ends with >

I know it is easy to adjust a single start and end character but I wish to search for more - e.g.. start with <span & ends with span>
I really cannot figure this out if I enter these parameters I get no response back, any help gratefully received.
Thanks

EXISTING CODE

Please Login or Register  to view this content.

NEW CODE

Please Login or Register  to view this content.

Hi
I believe I have modified the post with the required [code] tags now
Hopefully someone can help me resolve this problem now
Many Thanks

Hi there,
look at this:

Please Login or Register  to view this content.

You test 1 character agains 5 characters:
F.e.: if Your range value is '<span>' then the condition Mid("<span>", n, 1) will never be met, since '<' will never be equal to '<span'.
You have to change the lenght of string in MID, but then You also have to change the rest of IF-END IF according to what You want to extract.

Hope it helps

hm...
what should Your function actually do?
When the cell value start with '<span' and end with 'span>' then it should return original cell value?

You are welcome...