| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If String starts with a * (asterik)
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel E-2007 starts, but Installer also starts 3 times??? | Setting up and Configuration of Excel | |||
| Delete asterik mark | Excel Discussion (Misc queries) | |||
| How can I find an asterik "*" in a spreadsheet using ctrl+F? | Excel Discussion (Misc queries) | |||
| How to find if a string starts with a digit | Excel Worksheet Functions | |||
| Error when string length 1024 and starts with - | Excel Programming | |||
Linear Mode
