| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
is blank
Hi team
I wish to look at a cell value and take action if empty / blank If ActiveCell.Offset(5, 2).Value is blankThen MsgBox ... Ive had no luck with is null or is blank What simple solution am I missing, Ive trolled the help file (honest!) Thanks John |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
is blank
Hi John
How about If ActiveCell.Offset(5, 2).Value ="" Then MsgBox... //Per "John in Wembley" skrev i en meddelelse ... Hi team I wish to look at a cell value and take action if empty / blank If ActiveCell.Offset(5, 2).Value is blankThen MsgBox ... Ive had no luck with is null or is blank What simple solution am I missing, Ive trolled the help file (honest!) Thanks John |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
is blank
Sub ifblank()
If Len(Application.Trim(ActiveCell.offset(5,2))) < 1 Then MsgBox "empty" End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "John in Wembley" wrote in message ... Hi team I wish to look at a cell value and take action if empty / blank If ActiveCell.Offset(5, 2).Value is blankThen MsgBox ... Ive had no luck with is null or is blank What simple solution am I missing, Ive trolled the help file (honest!) Thanks John |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002: Return blank when VLOOKUP on blank cells | Excel Discussion (Misc queries) | |||
| Average Formula to display blank cell if named range is blank | Excel Worksheet Functions | |||
| Start Cell B1 then find first blank cell, insert subtotal, next non blank, then next blank, sutotal cells in between......... | Excel Programming | |||
| Copy to first Blank cell in Colum C Non blank cells still exist be | Excel Programming | |||
| Not showing blank and non blank items in filter mode for values | Excel Worksheet Functions | |||
Linear Mode
