VBA - find double quote (") in string

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
 
T

Tom Ogilvy

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

or

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

3 double quotes will work as well.
 
Top