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.
"Dave Peterson" wrote:
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/microsof...c.office.excel
Isn't there some sort of Apple Script that could be used, too?
Aussie Bob C wrote:
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.
--
Dave Peterson