| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checking iorAll blank cells in a column.
-- Mickey |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Checking iorAll blank cells in a column.
Dim rng as Range, cell as Range
On Error Resume Next set rng = Columns(5).SpecialCells(xlBlanks) On Error goto 0 if not rng is nothing then for each cell in rng mycheck(cell) Next end if "Mikey" wrote in message ... -- Mickey |
| 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 | |||
| HELP: Last row of the column containing blank cells between non-blank cells | Excel Worksheet Functions | |||
| Code works 1st time then Type Mismatch when checking for not blank cells | Excel Programming | |||
Hybrid Mode
