application.volatile

  1. T

    VBA - changing VOLATILITY of a UDF called PrevSheet(), which references Previous Tab

    Hi, I'm hoping to use the UDF PrevSheet() to replace INDIRECT() for referencing data in previous sheets, TO AVOID IT BEING VOLATILE BUT the code for the macro says this is volatile too. Can I simple replace the line: Application.Volatile True with Application.Volatile False By which i...
  2. S

    VBA ColorIndexofCF autocalc help - autocalc data in one worksheet is remove when same function calcs in another worksheet

    First, I am a novice to VBA, and I have scoured forums, websites, etc. trying to find the tweak(s) needed for my code to get it to work the way I want. I have been working on a spreadsheet that pulls data into specific cells based on conditional formatting of selections in other cells. I have...
  3. C

    User-defined function Excel 2010

    I am trying to create a custom function that will be used on multiple different sheets. Depending on the data on each sheet, the custom function needs to calculate a few different ways. One of the inputs needed for the function to know what to do is "NumNewDiags". I currently have another...
    • cwunderlich
    • Thread
    • application.volatile custom function recalculate user-defined functions
    • Replies: 3
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top