Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Ella Campbell   on Oct 12 In MS Office Category.

  
Question Answered By: Katrina Edwards   on Oct 12

I'm still not sure what you mean. Can you not use "exit
function" to exit the function  if a cell is false?

if blah blah then
exit function
end if

> exit function without altering the value from last recalculation
What value are we talking about?

This snippet...
With Application
.Calculation = xlManual
.MaxChange = 0.001
.CalculateBeforeSave = False
End With
.. is a recording of turning automatic calculation  off.

Also maybe you need to specify which type of parameter  you are
using.... ByRef or ByVal. They are both in help.

Share: 

 

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

 
Didn't find what you were looking for? Find more on User Function - is optional calculation possibe? Or get search suggestion and latest updates.


Tagged: