Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have haggled w/ this forever it seems. I want a universal (old and new
excel versions) way to see if a cell has anything in it. It may be text, number, or anything. in excel2000, ...if cells(i,j) < 0 then... worked, but it didn't work in an earlier version (I think 97). ....if application.isempty(cells(i,j)) then... doesn't work, but ...if isempty(cells(i,j)) then... works in 2000. This is interesting b/c I have come across instances where putting 'application' in front of a command allows it to work in 97, while it worked either way in 2000. If I don't see anything in the cell, I expect it to detect this empty field and skip over it, regardless of what version of excel the user has and regardless of whether I am looking for text or numbers or anything else. Is there a sure-fire way to accomplish this? thanks, mike allen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to detect characters in cell? | Excel Discussion (Misc queries) | |||
Is there a function to detect changes in any given cell? | Excel Worksheet Functions | |||
UDF - detect cell border | Excel Programming | |||
Detect when Active Cell Changes | Excel Programming | |||
Detect whether a row is completely empty | Excel Programming |