lifetime

  1. T

    Scope and lifetime of variables

    My understanding of a variable's lifetime is that if it is declared at the module level, it retains its vaue, even after the sub has finished running. So in my following code, after first running Test1 to the end, if I run Test2, the messagebox shows the value of 10, as expected. Dim a As...
  2. G

    variable scope problems

    I have "variable scope problems". I have read the help, and I think I understand it, and I have my code organized so that I should have no scope problems.. But I do. Mostly, my problem seems to occur when I have a Function or Subroutine procedure which calls another Function or Subroutine...

This Week's Hot Topics

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
Top