forcing a blank

D

Dave Peterson

Edit|Clear|Contents from the user interface.

Or from VBA:
activesheet.range("a1").clearcontents

But if your cell contains a formula, you can give the appearance of a blank
cell, but it won't be blank:

=if(a1>7,"",a1)
(in B1)

But it'll flunk this test:
=isblank(B1)

But you could check it to see if it looks blank:
=if(b1="","looks empty","I can see something")

or if you're used to entering spaces to clear the cell (a bad idea in most
cases):

=if(trim(b1)="","looks empty","nope")
 

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

MS Word normal.dot cannot be fixed 'text box' appears each time 4
Publisher adding blank page when printing my booklet... 2
Blank pages 0
Two columns followed by single page-width column on same page 0
Student & Home? 1
How to center adjust text above and image in a two column document. 1
Descenders clipped 0
Re-title multiple MS Project .mpp files at once 0

Top