speedup

  1. F

    Macro runs slowly but step-by-step is fast

    Hi all, I am trying to filter data from a table (not pivot table) and then move boxplot charts and scatter charts to different sheets. I tried to do this by looping at the beginning but I don't know how since every "category" is named differently and also I want to copy charts as pictures and...
  2. H

    Conditional formatting alternative

    Hi, I have an excel sheet that is designed as a map of my warehouse layout, I have 3 conditional formats run by a macro doing a countif calculations on 4800 cells using data from another worksheet to change the colour depending on the amount of activity in that given cell. The sheet runs...
  3. C

    Improving VBA execution speed when writing to a Excel worksheet

    As a follow-on to this thread: https://www.mrexcel.com/forum/excel-questions/997745-im-going-crazy-trying-get-cell-offset-working.html Now that I've got my VBA code working, I'm wondering if there is a way to speed it up. My code reads data from a small (12KB) log file, parses it into VBA...

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