Rick

I was look for a macro method that would enter the values 1 & 2 into the
cells, it appears Dave's use of xlFillCopy is not supported in xl2004 for Mac.

I may have to enter your formulas via a macro and copy cell values in place.
Sorry I left out the xl2004 note in this post.
I use both xl2007 and xl2004.

--
Thank you

Aussie Bob C
Little cost to carry knowledge with you.
Win XP P3 Office 2007 on Mini Mac using VMware.


"Rick Rothstein" wrote:

Actually, a slightly more simple formula... assuming Row 3 is the starting row, place a 1 in R3 and then use this formula in R4 and then copy it down as far as you want:

=1+MOD(R3,2)

--
Rick (MVP - Excel)


"Rick Rothstein" wrote in message ...
Put this formula in your "starting" cell in Column R (cell R3 from your example) and copy it down as far as you want...

=1+MOD(ROW(A2),2)

--
Rick (MVP - Excel)


"Aussie Bob C" wrote in message ...
Hi

Can I filldown column Q starting at Q3 the recurring numbers 121212 down to
lastcell in column R.

Example:
Cell
Q3 - 1
Q4 - 2
Q5 - 1
Q6 - 2
Q7 - 1
Q8 - 2

TIA
--
Thank you

Aussie Bob C
Little cost to carry knowledge with you.