optimise a code

  1. I

    Hundreds of Lockups, Formula Inefficiency, Help (Struggling to even define it to be honest)

    Hi, I have a timeline of various projects in excel with the people working on them. Each person may be working on multiple projects simultaneously and I want to create a table of all my people, showing which active projects theyÂ’re assigned to on any given week. I already have a table with the...
  2. PhBarreto

    There is a way to optimize this CODE? MRS EXCEL - PLS HELP!!

    Hello guys! I have a spreadsheet with 30 sheets and I have the code bellow to. There is a way to optimize this CODE? I want a smaller code. What do the same thing for all sheets... and if error, loop or go to next. Sub CopiarPainelEntregas() Dim LR As Long Dim resposta As Integer Dim...
  3. R

    Code optimization for financial analysis

    Good morning, I created the following code to make calculations and then copy the results in the "Cash Flow" sheet. It takes 15 seconds but I'm sure that the code can be optimized. In step 1) formulas are applied to a range of cells in "PTF" sheet; step 2) change the date and the formula are...
    • riga04af
    • Thread
    • analysis of data arrary optimise a code speed up macro
    • Replies: 0
    • Forum: Excel Questions
  4. C

    Memory Leak when expanding data from worksheet to worksheet

    Hi, I am encoutering "Out of Memory" error when running my macro, i have zoom down to this sub that make the memory usage increase from 100,000k to over 500,000k until the error hit This sub will take around 5k data and expand to more than 150k data in another sheet. The funny thing is when...
  5. L

    help to optimise a code

    Hi, can someone kindly help me optimise the following slow code.... it is currently taking upto 10s..... is there a way to make it real fast and furious? Sub ThirdRanked() Application.ScreenUpdating = False Application.Calculation = xlCalculationManual Application.EnableEvents = False...

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