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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

visual basic excel 2000 6
Disable Clear DContents command in excel - vba code?? 3
Excel Data pastes into 2 cells not 1 1
How to clear contents of multiple cells in Excel simultaneously 1
Clearing cells but also not clearing other dependent cells 4
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
How to Export Gmail Emails to PST Format? 4
Clear contents of cells hidden by autofilter 3

Back
Top