using =right() and =left() in VBA

[lhernandez]

I know this is very simple question and I have done this before I can just not remeber.
I have a cell the reads either ##C or ##TR.
I am trying to write an if statment stating
if the right value of sheet1 cells(x,y) = "C" then
etc.
else
if the right of sheet1.cells(x,y) = "TR" then
etcs...
end if
Can someone please help me!

 

[Norie]

Well I don't think either Left or Right are what you are looking for if there is always 2 characters/digits before what you want to test.

Select Case Mid(Cells(x,y),3)
       Case "C"
            ' do something
        Case "TR"
            ' do something else
        Case Else
            ' do something completely different
End Select

 

[erik.van.geit]

Hi,

surely when you type "left" or "right" in the VBA-helpfiles, you would get your answer
try this

If Right(Cells(1, 1), 1) = "C" Then MsgBox "hello"

kind regards,
Erik

EDIT: adjust last argument when you need two characters

If Right(Cells(1, 1), 2) = "CC" Then MsgBox "hello"

 

[lhernandez]

thank you both i was able to use both suggestions!