Re: Excel and empty cells
Re: Excel and empty cells
- Subject: Re: Excel and empty cells
- From: Paul Berkowitz <email@hidden>
- Date: Thu, 15 May 2003 09:47:59 -0700
On 5/15/03 6:22 AM, "Rich Carroll" <email@hidden> 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"
If a cell is empty, Value of the Cell is 0 (no quotes) in AppleScript .
If a cell has the numeric 0, Value of the Cell is 0.0 in AppleScript .
If a cell has a text "0" (kind of hard to do that, but it's possible if you
have prefixed a single quote to it in the UI), Value of the Cell is "0"
(with quotes).
--
Paul Berkowitz
_______________________________________________
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.