fast code

  1. L

    Variable Rows, Help Speeding Up

    Hello, I have the below piece of code that runs, but is extremely slow. I know the problem is the fact that it is looping through all 75000 rows. What I needs is, how do I change the code to just check the rows that actually have data in them? This is only a part of the overall code, I did...
  2. M

    VBA copy and paste - the fast way

    Hi there, i know there are lot of threads about this. I need to copy only values. So we did something like this to avoid clipboard: Worksheets("Sheet1").Range("C5:C31").Value = Worksheets("Sheet2").Range("A5:A31").Value Worksheets("Sheet1").Range("E5:E31").Value =...
  3. R

    Transferring Cell Information to VBA memory

    Hello everyone, I am designing a tool to identify whether a cell has inter or intra sheet dependents using VBA. The problem is the extremely slow speed due to interaction with worksheet and use of 'showarrows' and 'hidearrows' function. Can the entire sheet information be copied 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