Clearing Cell Contents

  • Thread starter Thread starter Lee
  • Start date Start date
L

Lee

I have a large grid of cells that users input numbers
into. This grid is then exported into a csv file.

The problem I'm having is when users clear a cell by using
the spacebar. The CSV export thinks there is data in
these cells which sometimes causes trailing commas past
the end of a data string.

Is there any way in VBA to clear the contents of all cells
within a range that are not greater than 0 or are
apparently blank (cleared by the spacebar)?

Any help is appreciated.

Thanks,

Lee
 
Back
Top