filldown recurring 121212

  • Thread starter Thread starter Aussie Bob C
  • Start date Start date
A

Aussie Bob C

Hi
Sorry should have added using Excel for Mac 2004

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.
Win XP P3 Office 2007 on Mini Mac using VMware.
 
Does xl2004 for the Mac support VBA?

If yes, then check your earlier post.

If no, you may want to ask in a forum dedicated to Mac's:
news://msnews.microsoft.com/microsoft.public.mac.office.excel

Isn't there some sort of Apple Script that could be used, too?
 
Thanks for the replies Dave.

Yes xl2004 for Mac does support VBA in a slightly limited degree i.e.
xlFillCopy not supported.
Where as xl2008 uses apple script
It also appears the code for Dim and Set statements is different.
I can use your code in xl2007 for Windows.

I'll check out the yor mac site link.

--
Thank you

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filldown recurring 121212 5
Select range from ActiveCell do to Lastcell in ColumnA 4
Select range from ActiveCell do to Lastcell in ColumnA 3
Show Activecell Date in MsgBox 3
Select range from ActiveCell do to Lastcell 5
Possible Combinations of scores 1
Find first value in column with formulas 3
excel sum values if cell matches a value 1

Back
Top