Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Macros

Macros

ResolvedVersion 2007

Fri 7 Oct 2011, 13:49 Delegate Christopher said...

Christopher has attended:
PowerPoint Introduction course
PowerPoint Intermediate Advanced course
Excel Intermediate course
Excel Advanced course

Macros

How do you know what part to remove in a macro to make it run faster?

Mon 10 Oct 2011, 16:52 Trainer Anthony said...

RE: Macros

Hi Christopher, thanks for your query. It's a bit of an art, I'm afraid. The macro won't run much faster by removing lines of code, unless those lines are taking a long time to process your information. The real way to significantly soup up the speed of your macros would be to code them from scratch in VBA, using loops and variables, rather than the script the macro recorder generates.

Hope this helps,

Anthony

Mon 17 Oct 2011: Automatically marked as resolved.

Excel tip:

Change the Default Width of All Columns in Excel 2010

If you want to change the width of the columns in your Excel 2010 spreadsheet, making them either larger or smaller, here's how:

In the Cells group on the Home tab, click Format.

Hover over the section called Cell Size and a drop down list will appear, select Default Width from this list.

In the Standard Width dialog box, enter the size you want to set as the default width and click OK.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Macros

Macros

RE: Macros

Excel articles

Excel tip:

Change the Default Width of All Columns in Excel 2010