Amending code to add array

**dms2228** · 09-06-2013, 01:38 PM

Hello everyone, I have been using the below code successfully on a handful of worksheets. However, when I use this code on a number of worksheets, it takes a very very long time to complete. I was wondering if instead of utilizing the If .Name <> code, I could insert an array of worksheets that I would like this code to run on. Is that possible? I am looking to minimize the run time of the macro, and I believe using an array may help that. If anyone could help that would be great! Any other recommendations are welcome as well!!

Please Login or Register  to view this content.

**Norie** · 09-06-2013, 01:42 PM

Changing to an array won't change the no of sheets the code runs on so won't change the running time.

What could speed things up is filtering the data to get the rows you want to delete.

**MarvinP** · 09-06-2013, 01:45 PM

Hi dms,

Here is a great link to help

http://www.cpearson.com/excel/optimize.htm

I'd try to ScreenUpdating = False first to see if that helps much.

Amending code to add array

LinkBack

Thread Tools

Rate This Thread

Display

Amending code to add array

Re: Amending code to add array

Re: Amending code to add array

Thread Information

Users Browsing this Thread

Similar Threads

Need help with amending code

Help Amending a bit of VBA code

Amending code

[SOLVED] Help amending code

[SOLVED] Help with Amending this Code Please

Bookmarks

Bookmarks

Posting Permissions