Active Row

[scrabtree23]

I would like to create an if statement based on an active row.

For example, something like this

If ActiveCell.Row = Range (C:C) Then



In other words, I only want the code to fire if the active cell is in column C

[shg]

C is a column

Please Login or Register  to view this content.

[scrabtree23]

Right you are. Thank you.

[shg]

You're welcome.

[MarvinP]

Hi scrabtree,

If you are using your code in an Event Macro and only want the macro to execute if the target cell is in Column C then this might be your code:

Please Login or Register  to view this content.

Read:
http://2toria.com/2010/07/10/using-i...t-in-vba-code/