Replace "#" with an integer in VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

I'm trying to write some code that will read the value in a cell, and if a
"#" appears somewhere in the string, it will be replaced with either a 1 or a
2 (depending on user entry).

I've tried using the Application.WorksheetFunction.Replace function, but I
can't get the arguements to work.

Any help that anyone can provide would be greatly appreciated.

Thanks in advance and have a great one,

Mike
 
Hi Mike

try using the substitute function instead e.g.

ActiveCell.Value =
Application.WorksheetFunction.Substitute(ActiveCell.Value, "#", 1)

Cheers
JulieD
 
You must log in or register to reply here.

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

Couple subs need help with 2
Adding additional rows in VBA based on character strings 1
Replacing the formula text's substring 2
How to write a VBA function which returns an integer 5
Excel VBA 1
Converting Integers to text 1
Clearing an integer variable 1
Modifying a LARGE text file 2

Back
Top