similar function for SUBSTITUTE in excel?

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

In VBA Excel 2007, is there a substitution for VLookup? 4
Need Help with Substitute Formulas, etc. 5
'Substitute' function with wildcards 1
More than i substitution 10
Substitute function 3
VBA Code for "" empty cell 2
double use of Substitution Function 2
Excel VBA 1

Back
Top