vba performance

  1. A

    Efficient VBA code for conditionally deleting rows in big excel sheets

    My excel sheet has 40 columns and more than 1,00,000 rows. I want to delete all the rows which contain cell with a string "NA" in any of the columns. I am struggling to find an efficient VB code for this on, which doesn't cause Excel to crash. Any suggestions? P.S. Exact number of rows and...
  2. G

    Excel-vba optimizing speed when importing data from excel sheet to excel table

    Having trouble with speed of a vba script for importing data into an excel table. Hoping someone here can help. As the comments in my code state this script takes about 8 seconds to import 100 rows of data. I would love to bring it down to fractions of a second. Sub ImportMyData()...
    • ggwptyvm
    • Thread
    • performance speed vba vba performance vba performance speed
    • Replies: 3
    • Forum: Excel Questions
  3. P

    Running VBA code from a button, the macro list, or VBA form

    Hello - I have a large spreadsheet with lots of pivot tables and data, and wrote a long VBA program that configures the pivot tables based on user selections which are made in a VBA form. The user selections are also stored in a worksheet within the file. I ran the code from the VBA form, and...

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