Even ODD Row Number Query

[gsaini]

Hi All, I am able to find out the correct function to work with Even and Odd rows.My small requirement is as below.

z = ActiveCell.row
If z = evern number then
MsgBox("Even row selected")
else
MsgBox("Odd row Selected")

I tried using MOD but Excel doen't like it.

Any Advice? Please

 

[Ruddles]

Duplicate threads here and here.

 

[Smitty]

Please stick to your Original Thread.