run code faster

  1. A

    Help improve .DBF import speed

    I am working on a project to automate importing multiple .dbf files into a single excel sheet. The idea being I can import a group of .dbf files representing one dataset and the trend/graphs I need are automatically generated. The .dbf files always have the same data columns/header (38 columns)...
  2. VBE313

    Is there a way that I can run this code faster?

    Dim rngstart As Range Dim l As Long, strCells As String ActiveSheet.Unprotect Password:="B28" Application.ScreenUpdating = False Set rngstart = ActiveCell l = ActiveCell.Row strCells = "F" & l Range(strCells).Select Rows(ActiveCell.Row).Select...
    • VBE313
    • Thread
    • 0.select rangestrcells.select rowsactivecell.row.select run code faster strcells
    • Replies: 1
    • Forum: Excel Questions
  3. L

    Hyperlink as Button for VBA Code

    When I was researching why my command buttons keep changing size, I came accross a comment suggesting the use of hyperlinks or images instead. I like the idea of a hyperlink as it would fit better on my dashboard, but I'm not sure wher to start. Does anyone have the method for attaching...
    • LORDMARKS
    • Thread
    • command button hyper link run code faster start vba vba & excel
    • Replies: 1
    • Forum: Excel Questions
  4. M

    Improving Macro Run Speed

    Hi, I have built a relatively large macro that I am now breaking down into chunks to re-edit and improve my run time. I am trying to write a code that will copy all cells in tabs from a saved workbook and paste them into new tabs in the active workbook (which will have a different name each...
  5. T

    Make the code crisper to enhance performance

    Dear all, below is the code that i am using to analyze some data. The code is taking around 2.2 minutes to run. Being a report for senior management this is too long. Please suggest ways so that it runs faster. Option Explicit Dim rw As Long Dim i As Integer Dim count As Integer Sub...

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