And in code, you can check to see if the cell is empty--no value and no formula:

if isempty(activesheet.range("a1").value) then
'it's empty
else
'it's got a value or formula
end if



J@Y wrote:

What function can be used to test if there is data in a cell or not?

--

Dave Peterson