Formula in a variable

[288enzo]

I've found much on how to use a variable in a formula, but how if possible do I use a formula for my variable?

As an example, in B5 I have 83a West Coast. I want my string variable to be =LEFT(B5,2)

The reason is because I plan on using Select Case.

Dim strArea As String
strArea = Sheets("Dealer Status").Range("Left(B5,2)")
Range("B:B").Delete
Select Case strArea
Case 83
Range("C2") = "00"
End Select

Another reason why I want to assign it to a String is because I plan on deleting the B column and will need to use the String after deleting the column.

I also tried

Dim strArea As String
strArea = Sheets("Dealer Status").Range("B5") = "=Left(B5,2)"
Range("B:B").Delete
Select Case strArea
Case 83
Range("C2") = "00"
End Select

 

[bebo021999]

How about

Sub test()
Dim strArea As String
strArea = Left(Sheets("Dealer Status").Range("B5"), 2)
Range("B:B").Delete
Select Case strArea
Case 83
Range("C2") = "00"
End Select
End Sub

 

[288enzo]

How about

Sub test()
Dim strArea As String
strArea = Left(Sheets("Dealer Status").Range("B5"), 2)
Range("B:B").Delete
Select Case strArea
Case 83
Range("C2") = "00"
End Select
End Sub

Thank you very much. What you did makes sense.