Optimize VBA Code

ambarrovecchio · Jun 29th 2007

Re: Optimize VBA Code

Filo65,
I tried your code and it came up with this error:

Run-time error '1004'
Application-defined or object-defined error

It pointed to this line:

Code

Sheets.Add.Name = WhtSht

Norie,

There are parts where I kept in the Range("A1").Select, because I'm a little anal about the spreadsheet looking "neat" when the macro is finished, rather than having random rows and columns highlighted. I'll research the text-to-columns and/or formulas and see if that method would be better.

Thanks everyone for your help! Keep the ideas coming!

**norie** · Jun 29th 2007

Re: Optimize VBA Code

If you didn't use select then random rows or columns wouldn't get highlighted in the first place.:confused:

filo65 · Jul 3rd 2007

Re: Optimize VBA Code

It would be good if you would post a zipped file to have overall view.

filippo

Dave Hawley · Jul 3rd 2007

Re: Optimize VBA Code

Change

Code

Sheets.Add.Name = WhtSht

To

Code

Sheets.Add().Name = WhtSht

and read about speeding up code and make use of the UsedRange Property of the Worksheet Object.

Optimize VBA Code

Participate now!

Share