VBA - find double quote (") in string
 

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

--
Message posted from http://www.ExcelForum.com

VBA - find double quote (") in string
 

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

or

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

3 double quotes will work as well.

--
Regards,
Tom Ogilvy

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

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


---
Message posted from http://www.ExcelForum.com/