RE: Excel Find Command.
RE: Excel Find Command.
- Subject: RE: Excel Find Command.
- From: "Script2" <email@hidden>
- Date: Mon, 9 Feb 2009 12:47:47 -0500
- Importance: Normal
Thanks Michelle
It worked.
Ruby
-----Original Message-----
From: applescript-users-bounces+script2=email@hidden
[mailto:applescript-users-bounces+script2=email@hidden]
On Behalf Of Michelle Steiner
Sent: Monday, February 09, 2009 10:24 AM
To: Applescript Users
Subject: Re: Excel Find Command.
On Feb 9, 2009, at 8:18 AM, Script2 wrote:
> What I need help is with if else statement
>
>
> Set fc to (find(range "A:A:" of worksheet "sheet1") what 5865)
> If found
> -----------------update record
> else
> -------------find next blank line and add new record
> end if
How about using a try-on error block instead?
-- Michelle
--
Tubal Litigation: Suing because of a misconception
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
tern.com
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