Cell vales

  • Thread starter Thread starter Mike
  • Start date Start date
Test its Value property for not being the empty cell...

If Range("A1").Value <> "" Then

or, alternately, test the length of the Value for being larger than zero...

If Len(Range("A1").Value) > 0 Then
 
If you want to look for an empty cell -- no formula that evaluates to "".

if isempty(worksheets("Somesheetnamehere").range("A1").value) then
'it's empty
else
'it's got something in it.
end if

checking for "" with something like this may not be enough:

if worksheets("Somesheetnamehere").range("A1").value = "" then
'cell looks empty, but it may have a formula that evaluates to ""
'it may even be empty
else
'cell has something in it for sure
end if
 
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

"DoEvents"-type behavior in Solver? 1
Create if partial match then copy and paste data from one cell to another 1
I want to make One Cell mandatory if another cell has a specific value , can anyone help me? 0
VBA set thick borders around non empty cells in range 0
Copy to an existing wb or create new wb if it does not based on ce 4
Run two macros for two different sheets 11
Macro to Combine Data from Multiple Sheets with Cell References 4
Need Macro... 8

Back
Top