when run Search, Then my GetMatch Formula IS DELETED from whole Worksheet

Hello i'm David



For unknown reason a Macro is deleting a entire Column E that have it set GetMatch Formula.
The Other formulas in the workbook remain ok.

I Think it have to be with Search macro(my Search) or GetMatch macro (Concat)

I Add a Comment Step in the Workbook (attach)

But anyway, This are the Step that i'm performing with the workbook :


1 Step (MAIN DATA)
=====
In Cell C1 and Cell C2 i have to be Paste on daily basis a 2 Long String.
(each string have 36 Numbers or More, and are separated by a Dash - )


Step2 (INPUT BOARD)
=====
I Extract The MAIN DATA In "Pieces" (C1 & C2) and is Copied to Cell C8 tru C33,
(Please Note that For this Extraction i'm Using LEFT, MID, RIGHT Function.)


Step 3 (GetMatch DATA)
=====
DATA From Cell C8 tru C33 Is Extracted and is Copied to Cell Range E8 TO E163
Note 1 : i have a Macro for this Function, and each Cell (E8 tru E163) have it Set the GetMatch Function to Extract the C8-C33 Data string


Step 4 (Search CELL)
=====
In Cell E4 I Insert a Group of Numbers that wants to SEARCH In Cell Range E8 to E163
NOTE : At this Point and Before Click the Form Control Button,The GetMatch Formula Still in range C8 to C163.


THE TWO ERROR
=============

ERROR #1 (Not HighLight Numbers located as First Digit)
---------
AFTER Numbers to be search are Inserted in Cell E4 and Command Button "Click Here To Search" is Click it,

Then

1-.If one (any) of the Numbers to Be Search in Cell 8 to Cell 163 Appear as a First Digit (lef side) in the String, Then this Number not Get Highlighted.

Error Example:

Numbers to be search (03 11 22 31 36 ) Then CLick in Form Control Button


The Number 11 22 31 36 are Highlighted, The Number 03 Is HightLighted as Long is as a Second Position in the String (See R-3)

COLUMN E
R:1 -> 02-09-12-14-19-29-31-36
R:2 -> 02-03
R:3 -> 03-04-05-11-17-22-24-28-30-35
R:4 -> 02-03-14-19-29-31-36


ERROR #2 (GetMatch Formulas In Cell C8 - C163 DISAPPEAR )
---------
After the Search is Done, The DATA String at Cell C8 to Cell C163 Still intact After Search.
BUT
The GetMatch Reference Formula Got Deleted Each time The Search Macro is Run .


NOTE : I don't really know where is the error, but in a Article of This Microsoft Excel Link,
They talk about the GetMatch Function, and Might i'm applying wrongly..



Please , need Help on this Issue


Best Regards

David