Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Fabiana Ferrrari   on Dec 02 In MS Office Category.

  
Question Answered By: Alice Hughes   on Dec 02

We need to identify the trigger conditions:

Is the condition likely to be caused by changing the values in B8 and B10?
Is it likely to be caused by the values in B8 and B10 changing as a result of
changes to another cell?
Is it likely to happen because the value of H5 changes as a result of changes
to another cell.
Do B8, B10, and H5 contain formulas or directly entered numeric values.

We also need to identify how much of an overhead you spreadsheet can stand.
Is your entire workbook, small, medium, large, enormous, or gigantic? (don't
worry too much what these mean exactly<g>) If, for example, your spreadsheet
has 10,000 rows each with 200 cells each of which contains a seven deep nested
IF formula incorporating multiple lookups, we will not want to fire the macro
on every change in every cell.

Share: 

 

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

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


Tagged: