Re: Excel and empty cells
Re: Excel and empty cells
- Subject: Re: Excel and empty cells
- From: Hanaan Rosenthal <email@hidden>
- Date: Thu, 15 May 2003 18:53:04 -0400
Hello Rich,
Try the cell's or range's formula property, it has a string value:
tell application "Microsoft Excel"
set theRange to Range "R1C1:R4C5" of Worksheet "Sheet1" of Workbook
"Workbook1"
Formula of theRange -- whose Formula = ""
end tell
--> {{"2", "3", "4", "7", "7"}, {"8", "7", "67", "", "7"}, {"6", "7",
"6", "5", "7"}, {"0", "9", "0", "7", "6"}}
--
Hanaan Rosenthal * Custom Flow Solutions
MEDIA AUTOMATION CONSULTING
401-487-2957 * email@hidden
* www.hanaan.com *
be successful... ...work less.
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.