a = Application.WorksheetFunction.Substitute(a, "niel", "")

--
Kind regards,

Niek Otten

"Ribap" <Ribap.23mxsn_1140619202.8991@excelforum-nospam.com> wrote in
message news:Ribap.23mxsn_1140619202.8991@excelforum-nospam.com...
>
> yeah, but i need to do this in vba code, and that code does not work in
> vba
>
>
> --
> Ribap
> ------------------------------------------------------------------------
> Ribap's Profile:
> http://www.excelforum.com/member.php...o&userid=25382
> View this thread: http://www.excelforum.com/showthread...hreadid=515303
>