Launching Macro Based on Selected Cell Value (first two characters?)

[Shiremaid]

Ok, so I have a macro to sort a very large list of materials by a variety of conditions.
The macro runs automatically when a cell on the master list spread sheet is selected and using If/ElseIf it sorts based on what cell they have selected.

Example
If ActiveCell = "ALUMINIZED" Then
ActiveSheet.Range("$A$14:$K$1945").AutoFilter Field:=2
ActiveSheet.Range("$A$14:$K$1945").AutoFilter Field:=4
ActiveSheet.Range("$A$14:$K$1945").AutoFilter Field:=1, Criteria1:= _"Aluminized"

Which is working perfectly. The problem I am having is that some of the cells are two lines so it looks like this

BE
BEARINGS
​

I don't know how to get it to launch based on that cell content because of the line break in there. Can I make it launch based on the first two characters only?

 

[JoeMo]

Assuming the line break is character 10 you could try:

If Activecell = "BE" & Chr(10) & "BEARINGS"

 

[Shiremaid]

Sorry, I get nothing.
Is there a way to get it an IF to activate based on only a few characters?

 

[JoeMo]

Sorry, I get nothing.
Is there a way to get it an IF to activate based on only a few characters?

Try:
If Activecell.Value Like "BE*" then

Did you test the cell contaning BE ... to see if it contains character 10?

 

[Shiremaid]

I'm not sure how to test for character ten. But the "Like" code is exactly what I need, thank you!

 

[JoeMo]

I'm not sure how to test for character ten. But the "Like" code is exactly what I need, thank you!

You are welcome - thanks for your reply.