| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Begins with
Try this:
If ActiveCell.Value Like "C1*" Then ActiveCell.Offset(0, -1) = ActiveCell.Value & "Primary" StephanieH wrote: Can anyone tell me how to correct his line? If ActiveCell.Value = "C1*" Then ActiveCell.Offset(0, -1) = "Primary" I'm basically trying to evaluate if the value in the cell begins with C1 then write the word "Primary" in the cell next to it. When I hover over ActiveCell.Value, it give me C1ARM so I know it's seeing it correctly, I guess just not recognizing the C1* part? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Begins with
Oops. I meant
If ActiveCell.Value Like "C1*" Then ActiveCell.Value = ActiveCell.Value & "Primary" wrote: Try this: If ActiveCell.Value Like "C1*" Then ActiveCell.Offset(0, -1) = ActiveCell.Value & "Primary" StephanieH wrote: Can anyone tell me how to correct his line? If ActiveCell.Value = "C1*" Then ActiveCell.Offset(0, -1) = "Primary" I'm basically trying to evaluate if the value in the cell begins with C1 then write the word "Primary" in the cell next to it. When I hover over ActiveCell.Value, it give me C1ARM so I know it's seeing it correctly, I guess just not recognizing the C1* part? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Max if variable begins with | Excel Worksheet Functions | |||
| Sumif and begins with | Excel Discussion (Misc queries) | |||
| If statement - begins with | Excel Discussion (Misc queries) | |||
| IF Function - Begins With | Excel Discussion (Misc queries) | |||
| How do I type in a number that begins with zero? | Excel Discussion (Misc queries) | |||
Linear Mode
