similar function for SUBSTITUTE in excel?
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?
|