call sub

  1. P

    Call a sub routine from another module

    Hi, I am writing a lot of code and have separated each section in different modules For example, I have one module titled OpenR2D2 and another titled StoreName I want the sub in StoreName to run at the end of OpenR2D2 but I get this compile error "expected variable or procedure, not...
  2. L

    how to stop the parent sub when a child (i.e. called) sub stops in the middle

    I have a procedure that looks like this: sub parent() call child1 call child2 end sub My question is, since child1 grabs the correct files, and child2 processes the new files, when child1 stops (i.e. feed file not ready to be grabbed), the whole thing should stop right there. But when I...
  3. C

    Call Sub using Print Range Variables

    I needed a sub that could be used for various range on various sheets. each sheet has different buttons to initiate a print dependant on parameters in the Action for the button sub. It took a few days and several headaches to figure it out. There may be other short cuts but this does work. I...

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