xl2003

  1. T

    Can VBA be used to do 'For Each' with Public Const?

    Probably a bit of a tough one to describe but I'll do my best: I've got around 147 sub routines that do the same thing but with different URLs. Is there a way to use a loop to say 'Hey, for each URL in the PUBLIC_Declarations sub routine do this with it and then stop at the end'. All 147 sub...
  2. T

    XL2003 VBA: Replacing DIV/0 Error with String

    Hi, I have a sheet with rows of cells with values. In X column I have a formula that looks for the MIN value of these cells and displays it. The cells in the rows are populated from another sheet that grabs the data from a URL and some jiggery pokery through VBA. The row cells show the...
  3. T

    Call "Macro_Name" then pass back to macro calling?

    Hi, I want to reduce the amount of editing I have to do on a lot of macros. The top 10 lines of each of my modules are unique to that module but the other 100+ lines beneath these 10 are the same in each module. Is there a way to call a Macro2 that can contain these 100+ lines from Macro1...
  4. T

    XL2003 - Create A Macro Execution Progress Checklist with Userform

    Hi, I have 24 macros that each execute two web queries, pull the data into a sheet, do some fancy manipulation and then put some values into another worksheet to display for me. Each macro calls the next until the last macro. These executions can take some time to complete and so I was...

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