Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell vales
I am trying in a macro to check if a cell in a work sheet is NOT blank.
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell vales
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 -- Rick (MVP - Excel) "Mike" wrote in message ... I am trying in a macro to check if a cell in a work sheet is NOT blank. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell vales
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 Mike wrote: I am trying in a macro to check if a cell in a work sheet is NOT blank. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return multiple vales from a different spreadsheet into one cell | Excel Discussion (Misc queries) | |||
Equation Editor and substituting vales | Excel Programming | |||
Counting Unique Vales in a column | Excel Worksheet Functions | |||
extract matching vales | Excel Discussion (Misc queries) | |||
Need an OR Function that will allow for Text vales......... | Excel Worksheet Functions |