Lists

Open Menu Close Menu

Terms and Conditions
Lists hosted on this site
Email the Postmaster
Tips for posting to public mailing lists

Excel 2004 issue

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Excel 2004 issue

Subject: Excel 2004 issue
From: Jan Bultereys <email@hidden>
Date: Thu, 17 Dec 2009 14:33:04 +0100
Thread-topic: Excel 2004 issue

Title: Excel 2004 issue

Does anyone knows why this works in Excel 2008 and not in Excel 2004 (version 11.5.5)

tell application "Microsoft Excel"
    tell active sheet of active workbook
       set inputFormula to "=COUNTIF(C8:C600;A2)"
        set formula of cell "D2" to inputFormula
   end tell
end tell

I don’t get an error, the formula just doesn’t get placed in the cell.

Other formulas eg. =COUNT(C8:C600) seems to work without any problem

Many thanks for any feedback
Jan

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users

This email sent to email@hidden

Follow-Ups:
- Re: Excel 2004 issue
  - From: Paul Berkowitz <email@hidden>

Prev by Date: Re: Cupsfilter Scaling
Next by Date: Re: difficulties with read file applescript
Previous by thread: Re: do shell script and full path to unix command
Next by thread: Re: Excel 2004 issue
Index(es):
- Date
- Thread