| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checking for all blank cells in a range orcolumn.
How do I check to see if all the cells in a column are blank so I can skip
several lines of code which run a "text to columns" procedure but get hung up when the cells are all blank. It works fine when there is data in at least 1 cell. Thanks -- Mickey |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Checking for all blank cells in a range orcolumn.
Hi Mikey,
this could meet your requirements: If Application.CountA(Columns(1)) = 0 then Msgbox "First column is empty" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IS BLANK checking 2 Cells | Excel Worksheet Functions | |||
| checking for blank cells when using vlookup | Excel Worksheet Functions | |||
| Checking Blank Cells | Excel Worksheet Functions | |||
| Checking iorAll blank cells in a column. | Excel Programming | |||
| Code works 1st time then Type Mismatch when checking for not blank cells | Excel Programming | |||
Linear Mode
