VBA - find double quote (") in string

  • Thread starter Thread starter Brassman
  • Start date Start date
B

Brassman

I need to know if the far right character in a cell is a doublequot
("). How can I do this? example (doesn't work):

If Right(Range("A1").Value,1) = " Then *Do some Action* else *d
another action
 
If Right(Range("A1").Value,1) = chr(34) Then

or

If Right(Range("A1").Value,1) = """" Then

3 double quotes will work as well.
 
Back
Top