If String starts with a * (asterik)
if left(mycell.value, 1) = "*" then
'skip it
else
'do the work
end if
Benjamin wrote:
I need to do loop of actions on a list of strings.
If the string begins with an * it's not supposed to be changed or edited.
Everything else should be.
How to search and tell if the vba string starts with a *
something with MID, or Left maybe?
Little help... still learning vba here.
--
Dave Peterson
|