200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Hi all,
I've been using the MOD function to determine if a row is odd or even but people who read through the file often get confused or I simply forget how to use it if I haven't done so for a few months....
Is there a simpler way to determine if a row is odd or even?
Thanks!
Liz
If you do NOT have any rows hidden, you can start in Row 1 and put 'ODD', go to row 2 put 'EVEN', then copy (Rows 1 & 2) to some reasonably large number down. You could put in first Column (A). Hide it if you'd like so it's not in the way. Curious, why do you need to know whether or not a row is odd or even?
