PDA

View Full Version : Search for character within a value (VBA)



Seanconn520
05-22-2013, 11:02 AM
What I want to do is search through a column and for each value that has an asterisk in it I want to make that value 0. My code should look something like this

For each cl in range("a1:a200")
If cl.value contains "*" then
Cl.value = o
End if

SamT
05-22-2013, 02:06 PM
Use the VBA function InStr

If "*" is in a formula use
InStr(cl.Formula, ....

If "*" is just character use
InStr(cl, .....

snb
05-23-2013, 12:36 AM
Sub M_snb()
Columns(1).Replace "*~**", 0
End Sub