| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checking when target.values are empty. What am I doing wrong?
I have the following code
If Target.Offset(0, 0).Value Target.Offset(-1, 0).Value And _ Target.Value Is Not Empty And _ Target.Offset(0, 1).Value Is Not Empty And _ Target.Offset(0, 2).Value Is Not Empty And _ Target.Offset(0, 3).Value Is Not Empty And _ Target.Offset(0, 4).Value Is Not Empty And _ Target.Offset(0, 5).Value Is Not Empty And _ Target.Offset(0, 6).Value Is Not Empty Then |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Checking when target.values are empty. What am I doing wrong?
If Target.Value Target.Offset(-1, 0).Value and _
application.counta(Target.Resize(1,7)) = 7 then -- Regards, Tom Ogilvy "Barb Reinhardt" wrote: I have the following code If Target.Offset(0, 0).Value Target.Offset(-1, 0).Value And _ Target.Value Is Not Empty And _ Target.Offset(0, 1).Value Is Not Empty And _ Target.Offset(0, 2).Value Is Not Empty And _ Target.Offset(0, 3).Value Is Not Empty And _ Target.Offset(0, 4).Value Is Not Empty And _ Target.Offset(0, 5).Value Is Not Empty And _ Target.Offset(0, 6).Value Is Not Empty Then |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Checking empty cells | Excel Programming | |||
| Checking if the TARGET has been deleted | Excel Programming | |||
| checking for empty rows before copying? | Excel Programming | |||
| error checking reports a value in the formula is of the wrong dat. | Excel Worksheet Functions | |||
| Checking if Target is within different ranges | Excel Programming | |||
Linear Mode
