vba effifiency

  1. S

    VBA: Am I double-calling a Sub given nested If statements? Or other inefficiencies?

    Hello, I'm new to VBA and trying to make a custom Dashboard for a manager. Below lies my attempt at creating a data refresh and save macro that will be tied to a button on the "Dashboard" sheet. My main question is: Am I actually calling the RefreshData() sub twice in WriteData(), thereby...
    • SirGruffles
    • Thread
    • macros macros and vba vba vba effifiency vba help vba if else statement
    • Replies: 8
    • Forum: Excel Questions
  2. F

    VBA - Populate 270 by 366 sheet from large input workbook

    Crappola! Just spent 45 minutes posting VBA question. Answered phone, yakked, Mr. Excel timed out, and I lost the Thread. So, this time - highly summarized... Input sheet containing 150,000 + rows. Each row contains item, date, and amount. I want read each row and populate a 270 row by 366...

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