| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
IsEmpty - what's the opposite?
This works great -
If cll.Value = "R" And IsEmpty(cll.Offset(0, 2)) Then .... I need the same statement, but "not empty" - been searching, but can't find it! Any help appreciated! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
IsEmpty - what's the opposite?
Theo,
how about Not IsEmpty? If cll.Value = "R" And Not(IsEmpty(cll.Offset(0,2))) Then HTH, Conan "Theo" wrote in message ... This works great - If cll.Value = "R" And IsEmpty(cll.Offset(0, 2)) Then .... I need the same statement, but "not empty" - been searching, but can't find it! Any help appreciated! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
IsEmpty - what's the opposite?
Soooo close... Try Not IsEmpty...
If cll.Value = "R" And Not(IsEmpty(cll.Offset(0, 2))) Then .... I like adding in the extra quotes. -- HTH... Jim Thomlinson "Theo" wrote: This works great - If cll.Value = "R" And IsEmpty(cll.Offset(0, 2)) Then .... I need the same statement, but "not empty" - been searching, but can't find it! Any help appreciated! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
IsEmpty - what's the opposite?
That did the trick!
Thank you Jim T "Jim Thomlinson" wrote: Soooo close... Try Not IsEmpty... If cll.Value = "R" And Not(IsEmpty(cll.Offset(0, 2))) Then .... I like adding in the extra quotes. -- HTH... Jim Thomlinson "Theo" wrote: This works great - If cll.Value = "R" And IsEmpty(cll.Offset(0, 2)) Then .... I need the same statement, but "not empty" - been searching, but can't find it! Any help appreciated! |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
IsEmpty - what's the opposite?
Try:
If cll.Value = "R" And Not IsEmpty(cll.Offset(0, 2)) Then RBS "Theo" wrote in message ... This works great - If cll.Value = "R" And IsEmpty(cll.Offset(0, 2)) Then .... I need the same statement, but "not empty" - been searching, but can't find it! Any help appreciated! |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
IsEmpty - what's the opposite?
Dim cll As Range
For Each cll In Selection If cll.Value = "R" And Not IsEmpty(cll.Offset(0, 2)) Then 'do something End If Next Gord Dibben MS Excel MVP On Thu, 24 Jan 2008 14:09:55 -0800, Theo wrote: This works great - If cll.Value = "R" And IsEmpty(cll.Offset(0, 2)) Then .... I need the same statement, but "not empty" - been searching, but can't find it! Any help appreciated! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IsEmpty | Excel Programming | |||
| Can i use IsEmpty and IF this way? What's wrong here? | Excel Programming | |||
| Help with IsEmpty | Excel Programming | |||
| isempty | Excel Programming | |||
| vba: isempty | Excel Programming | |||
Hybrid Mode
