VBA speed performance issues with nested loops during import to table range

**ggwp** · 06-29-2016, 07:03 AM

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.

Please Login or Register  to view this content.

**Bernie Deitrick** · 06-29-2016, 09:16 AM

Don't iterate. Apply a filter to the first column that hides all the data that you don't want, then copy the entire table and paste it with one line of code. If you need to change the numberformat, apply it to entire columns rather than cell by cell.