Excel Find Command.
Excel Find Command.
- Subject: Excel Find Command.
- From: "Script2" <email@hidden>
- Date: Mon, 9 Feb 2009 10:18:15 -0500
- Importance: Normal
Excel find command work fine as long as it find the search data
Set fc to (find(range "A:A:" of worksheet "sheet1") what 5865)
Display dialog (get address fc)
When it does not find the search data it gives as error message "find does
not understand find command". I would like to add "if not found", can anyone
give me the syntax for this. I tried several if founds but nothing works.
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
Thanks
Ruby
_______________________________________________
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