View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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