Quick code for "If target cell is in a particular column"

ChristineJ · Jun 17, 2012

I would like to add one more "And" to the code below: If Target is in Column M

Code:

 If Target <> "" And Range("B1") = 1 Then[/code)

Thanks!

Marcelo Branco · Jun 17, 2012

Maybe

Code:

 If Target <> "" And Range("B1") = 1 And Target.Column = 13 Then

M.

ChristineJ · Jun 17, 2012

Just what I needed. Thank you so much!

Marcelo Branco · Jun 17, 2012

ChristineJ said:
Just what I needed. Thank you so much!

You are welcome and thanks for the feedback

M.