ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Begins with (https://www.excelbanter.com/excel-programming/380890-re-begins.html)

Don Guillett

Begins with
 
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?





All times are GMT +1. The time now is 05:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com