LinkBack URL
About LinkBacks
Sorry to keep on, but when I do this
=IF(Filled(AA7),"yes","no") i get a yes if filled but if not i get #value! - any ideas?
Sorry to keep on, but when I do this
=IF(Filled(AA7),"yes","no") i get a yes if filled but if not i get #value! - any ideas?
wait....do you set the function return value for "" to a zero?
Ernest
Please consider adding a * if I helped
Nothing drives me crazy - I'm always close enough to walk....
IE:
Function Filled(MyCell As Range) If MyCell.Interior.ColorIndex > 0 Then Result = 1 Else Result = 0 End If Filled = Result
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks