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 12:34:17 -0400
Look at the formula property of the cell.
It has a string value and contains whatever was typed in the cell.
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"}}
On Thursday, May 15, 2003, at 09:22 AM, Rich Carroll wrote:
>
Does anyone know how in Excel you could validate that a range of cells
>
all
>
actually have data in them? I would like to be able to tell if a cell
>
is
>
empty as opposed to a cell with a "0"
>
Thanks
>
--
>
Richard McCormick-Carroll
>
Application Specialist
>
Capps Digital Development Group
>
email@hidden
>
email@hidden
>
312.220.1679 @ Desk
>
312.520.1679 @ Cell
>
www.cappsdigital.com
>
_______________________________________________
>
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.
>
>
--
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.