Re: Excel Range Crash
Re: Excel Range Crash
- Subject: Re: Excel Range Crash
- From: Paul Berkowitz <email@hidden>
- Date: Mon, 25 Feb 2008 21:16:21 -0800
- Thread-topic: Excel Range Crash
What line of script caused the crash, in your opinion?
--
Paul Berkowitz
> From: Bruce Robertson <email@hidden>
> Date: Mon, 25 Feb 2008 21:11:41 -0800
> To: AppleScript-Users <email@hidden>
> Subject: Excel Range Crash
>
> Trying to do some basic applescripting of Excel.
>
> I'm getting application crashes.
>
> Excel 2008 (12.0)
>
> 10.5.2, Macbook
>
> This is a Windows spreadsheet received from a client.
>
> The crash appears to result from a sum formula like this:
>
> Sum( B2*15, C2*18, D2*18, E2*24 )
>
> Where text has been written into one of the cells such as B2, thus causing
> the sum result to show #Value!
>
> Is there a way for applescript to read a cell error like that and not crash
> the application?
>
> _______________________________________________
> 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
>
_______________________________________________
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