View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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