in vba what is the similar function for SUBSTITUTE in excel? Can u pls help me?

REPLACE

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"neb" wrote in message
...
in vba what is the similar function for SUBSTITUTE in excel? Can u pls
help me?

This is my code:

Sub nebs(Mycell)
nebs = Substitute(Mycell," ","")
End sub

(I want to make it as a function in excel using visual basic editor but
Substitute function is not defined/not recognized. I use REPLACE instead but
it asks me for a value...any help?)thnks.



"Bob Phillips" wrote:

REPLACE

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"neb" wrote in message
...
in vba what is the similar function for SUBSTITUTE in excel? Can u pls
help me?

ITS WORKING NOW THNKS SO MUCH

"Bob Phillips" wrote:

REPLACE

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"neb" wrote in message
...
in vba what is the similar function for SUBSTITUTE in excel? Can u pls
help me?