Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Empty Cells!??
For each cell in Selection
if not isempty(cell) then if cell.Value = "" then cell.clearContents end if end if Next Regards, Tom Ogilvy Huyeote wrote in message ... Hi, all, I'm working on an XL spreadsheet which lists debtors ageing. I found there are many cells obviously contain nothing in a data range. But when I use IsEmpty function or Specialcells(xlCellTypeBlanks) property to examine the cell, it does have something so that I can't use Areas property to work on discrete blocks of cells which I think contain values. Can anybody tell me what's possibly in those apparently empty cells and how to clear the contents? Thanks! Huyeote |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Empty Cells!??
Thanks, you procedure works. But do you have any idea what indeed in the
cells? Huyeote "Tom Ogilvy" wrote in message ... For each cell in Selection if not isempty(cell) then if cell.Value = "" then cell.clearContents end if end if Next Regards, Tom Ogilvy Huyeote wrote in message ... Hi, all, I'm working on an XL spreadsheet which lists debtors ageing. I found there are many cells obviously contain nothing in a data range. But when I use IsEmpty function or Specialcells(xlCellTypeBlanks) property to examine the cell, it does have something so that I can't use Areas property to work on discrete blocks of cells which I think contain values. Can anybody tell me what's possibly in those apparently empty cells and how to clear the contents? Thanks! Huyeote |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula refers to empty cells even when cells contains data | Excel Worksheet Functions | |||
skip cells with zero values in chart (cells not empty) | Charts and Charting in Excel | |||
Excel - Autom. Filter "Empty / Non Empty cells" should come first | Excel Discussion (Misc queries) | |||
When I SUM cells & 1 is empty I need the result to be empty not 0 | Excel Discussion (Misc queries) | |||
How can I convert empty strings to empty cells? | Excel Discussion (Misc queries) |