Replace with macro

[YasserKhalil]

Hello everybody
I have a range ("A1:A100") and some cells have within its text the following pattern
(anytext)
I want to replace that pattern with "" so as to get rid of this pattern

 

[prajul89]

the problem is that the length of this pattern isn't constant
maybe 10 or 12 or 20 string length!!!

Just give some examples of your 'pattern'

 

[prajul89]

Just replace "(*)" to "" and record and a macro while replacing it. and then edit it!

 

[Ruddles]

Oops, to get rid of the brackets as well as the text inside them that line of could should read:-

[FONT=Fixedsys]     ws.Cells(iRow, "A") = Left(ws.Cells(iRow, "A"), iPosOpen [COLOR=red]-1[/COLOR]) & Mid(ws.Cells(iRow, "A"), iPosClose [COLOR=red]+1[/COLOR])[/FONT]

 

[YasserKhalil]

Thank you very much Mr. Ruddles
It's solved

Can you help me with this topic??
http://www.mrexcel.com/forum/showthread.php?t=572619&page=2

 

[Ruddles]

It's solved now, yes?