code to work for odd rows only

**kosherboy** · 07-04-2014, 10:16 AM

Hi,
I am trying to add to this "if" statement that it should only work for rows that are odd and i came up with this:

Please Login or Register  to view this content.

but it doesn't work.
Any ideas?

**kosherboy** · 07-04-2014, 10:26 AM

If it's helpful here is the whole code

Please Login or Register  to view this content.

**AB33** · 07-04-2014, 10:40 AM

Try this line

Please Login or Register  to view this content.

and add end if

OR

Please Login or Register  to view this content.

**kosherboy** · 07-04-2014, 10:49 AM

Hi AB33,
Your 2nd suggestion worked just fine.
Thanks!

**mikerickson** · 07-04-2014, 10:53 AM

You could avoid testing for odd row if the loop only went through odd row numbers

Please Login or Register  to view this content.

**kosherboy** · 07-04-2014, 10:58 AM

Hi mikerickson,
That is an impressive alternative.
Thanks.

Re: code to work for odd rows only