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