Logo 
Search:

MS Office Answers

 Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Clifford Chapman   on Jan 11 In MS Office Category.

forms


  
Question Answered By: Fedde Bakker   on Jan 11

I was surprised when I found that

Range("B6").Value + Range("B7").Value + Range("B10").Value +
Range("B14").Value => 3

results in True if the cells  contain strings.

if application.WorksheetFunction.Sum(Range("B6,B10,B14")) >= 3
might work  better?

Share: 

 

This Question has 2 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on forms Or get search suggestion and latest updates.


Tagged: