Re: Empty cell and a the empty String

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: JE McGimpsey (jemcgimpsey_at_mvps.org)
Date: 09/13/04

Date: Mon, 13 Sep 2004 09:12:26 -0600

Yes. A null string is a value. So

Empty cell:

?IsEmpty(ActiveCell.Value)
True

Cell with null string (e.g., returned by a formula, eg. =IF(TRUE,"")):

?IsEmpty(ActiveCell.Value)
False

However, XL confuses the issue by clearing the cell if a null string is
assigned as a value:

    ActiveCell.Value = ""
    ?IsEmpty(ActiveCell.Value)
    True

In article <15BECD21-5D31-495E-B839-A1C3C0881A37@microsoft.com>,
Niklas <Niklas@discussions.microsoft.com> wrote:

> Are their any differances between an empty cell and a cell containing the
> empty String?

Relevant Pages

Re: To sum hours
... an empty cell in the last row of the table, ... Dim Secs As Long, i As Long, s As String, m As String, h As String, myrange ... "Sami" wrote in message ... I can not> use Exel, because I´m making a scrips for TV and it has a lot of text and> adding Exel makes the files too difficult to handle. ...
(microsoft.public.word.tables)
RE: Need macro that concatenates cells with text
... Sub sentences() ... Dim s As String, v As String ... A4: (empty cell) ...
(microsoft.public.excel.programming)
Re: Converting a constant to a number
... select an empty cell and copy this cell ... and pasting the information into EXCEL ... > I wanted to know if there was a way to convert the STRING ...
(microsoft.public.excel.worksheet.functions)
Re: Formula Error - Assign number to unique values.
... =countif() treats everything as text. ... When I want to convert a text string that's masquerading as a number to a real ... Select an empty cell ... Aldridge" wrote: ...
(microsoft.public.excel)
Re: Type mismatch error
... Value is a numeric, Text is a string. ... She's probably got an empty cell or something, but as usual she's not providing ... test the Text property first, ... cols = cols + 1 ...
(microsoft.public.vb.general.discussion)