Identifying a value

  • Thread starter Thread starter jtrevill
  • Start date Start date
J

jtrevill

How, using VB, can you determine the difference between a zero and
blank cell?

Thanks
 
The VBA IsEmpty function you can use if a cell is really empty

Sub test()
If IsEmpty(Range("A1")) = True Then
MsgBox "blank"
Else
MsgBox "not blank"
End If
End Sub
 
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

I want to make One Cell mandatory if another cell has a specific value , can anyone help me? 0
Use specialcells to identify specific values 1
Format cells help 2
Substituting zero values in blank cells 5
Print variable number of rows of spreadsheet 1
Cell values not being properly evaluated by VLOOKUP() orSUMPRODUCT()... why? 1
Identify adjacency cells with same value 3
PivotTable Custom Field - formula for no value, with blank cell displayed? 6

Back
Top