similar function for SUBSTITUTE in excel?

B

Bob Phillips

REPLACE

--
HTH

Bob Phillips

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

neb said:
in vba what is the similar function for SUBSTITUTE in excel? Can u pls
Click to expand...
help me?
 
N

neb

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.
 
Top