Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
If that doesn't work, try
if ucase(left(activecell,2))="C1" then .... -- Don Guillett SalesAid Software "StephanieH" wrote in message ... 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 | |
|
|
![]() |
||||
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) | |||
Begins with | Excel Programming | |||
IF Function - Begins With | Excel Discussion (Misc queries) |