Hi
try something like
activecell.formula="=REPLACE(a8,8,(SEARCH(""|"",a8 )-SEARCH
(""="",a8)),"""")"


-----Original Message-----
I'm having problems using the | character in VBA that I
can use easily
in an Excel formula.

I use the following formula in Excel:

=REPLACE(a8,8,(SEARCH("|",a8)-SEARCH("=",a8)),"")

and when I convert this over to VBA, it gives me a
warning that | is
not a valid char.

Then I tried using

=REPLACE(a8,8,(SEARCH(CHAR(124),a8)-SEARCH("=",a8)),"")

instead and the formula ends up coming across as FALSE as
the final
result.

Anyone know what to do with this?

thanks,
skyler
.