check for empty cell

's Computer Specifications

I need to ckeck if a cell contains a value or if it is empty. If there is
noting in the cell then a msg box needs to be displayed.

's Computer Specifications

One way:

If IsEmpty(Range("A1").Value) Then _
MsgBox "Cell A1 is empty."

In article <B8B0AEA7-26A4-4B8C-920B-(E-Mail Removed)>,
ingalla <(E-Mail Removed)> wrote:

> I need to ckeck if a cell contains a value or if it is empty. If there is
> noting in the cell then a msg box needs to be displayed.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Best way to check if cell is empty??	Robert Crandal	Microsoft Excel Programming	1	26th Dec 2009 04:37 AM
Best way to check if cell is empty??	Robert Crandal	Microsoft Excel Programming	2	23rd Dec 2009 01:26 PM
How do I check for an empty cell in a formula?	sasquatchbill	Microsoft Excel Misc	4	8th Aug 2006 03:55 PM
Check current cell is empty	bobocat	Microsoft Excel Discussion	3	6th Jul 2006 11:13 PM
vba - check if cell is empty	joao	Microsoft Excel Programming	6	18th Nov 2003 03:12 PM