If... Then Referencing Column A

[Rodney Jorgensen]

I am writing error handling for some code and I want to write an If... Then Statement, but do not know how to reference the Rows Cell in Column A.



If The Rows Cell in Column A <> = "Tickler "Y"" Then
MsgBox "Please Select the Correct Cell!", vbExclamation, "ERROR!"
Exit Sub
Else
Rest of my code

 

[Paddy1979]

Hi, try

If cells(target.row,1).value =

 

[Rodney Jorgensen]

I got this to work

If Cells(ActiveCell.Row, 1).value <>

Now, The Text in the Cell is Tickler "Y" The Y has quotation marks and when you try this statement below I get a

Compile error Expected: Then or GoTo. How can I reference that cell value with the quotation marks around the Y?

If Cells(ActiveCell.Row, 1).value <> "Tickler "Y"" Then

Thanks

 

[Paddy1979]

Try

If Cells(ActiveCell.Row, 1).Value <> "Tickler ""Y""" Then

 

[Rodney Jorgensen]

It did not work.

 

[Paddy1979]

Hmm works ok for me can you paste all of your code the problem may be elsewhere

 

[Rodney Jorgensen]

Oops. I see that there are 3 """ after the Y. I added in the 3rd one and it worked.

Thanks

 

[Paddy1979]

Good stuff