| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
find an empty cell or null value
How do you find out if a cell is null? The datatype for that field is
integer. I want to test for a empty cell. I'm not sure if either one of these is correct. Thanks If .Cells(iRow, 19).Value = "" if .Cells(iRow, 19).Value isNull |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
find an empty cell or null value
This is probably your best bet
If Trim(.Cells(iRow, 19).Value) = "" Just in case your cell has blank spaces in it... -- HTH... Jim Thomlinson "Janis" wrote: How do you find out if a cell is null? The datatype for that field is integer. I want to test for a empty cell. I'm not sure if either one of these is correct. Thanks If .Cells(iRow, 19).Value = "" if .Cells(iRow, 19).Value isNull |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
find an empty cell or null value
if .cells(irow,19).value = "" then
will test to see if the cell is empty or if the cell contains a formula that evaluates to "" or if the cell contains a 0 length string (like just the apostrophe (')) =if isempty(.cells(irow,19).value) then will check to see if the cell is really empty--nothing at all in it. Janis wrote: How do you find out if a cell is null? The datatype for that field is integer. I want to test for a empty cell. I'm not sure if either one of these is correct. Thanks If .Cells(iRow, 19).Value = "" if .Cells(iRow, 19).Value isNull -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| setting a cell to 'empty' or blank or null ? | New Users to Excel | |||
| How do you stop excel from charting empty cells/null values as zer | Charts and Charting in Excel | |||
| make cell contents equal to null value - not blank, but empty | Excel Worksheet Functions | |||
| Please help find the next empty cell | Excel Programming | |||
| Testing for null or empty | Excel Programming | |||
Linear Mode
