Return to Answer

From (code generated with macro recorder):

To:

From:

To:

From (code generated with macro recorder):

To:

From:

To:

You may access them with []. Which is really beautiful, compared to the other way. Check yourself:

Try always to refer the Worksheet as well

This is probably the most common mistake at the vba. Whenever you copy ranges, sometimes the worksheet is not referred and thus VBA considers the ActiveWorksheet.

• A good example, when you could be justified to use .Activate and .Select is when you want make sure, that a specific Worksheet is selected for visual reasons. E.g., that your Excel would always open with the cover worksheet selected first, disregading which which was the activesheet when the file was closed. Thus, something like the code below is absolutely

ok:

• Another good example is when you need to export all sheets in one PDF file, as mentioned in this case - How to avoid select/active statements in VBA in this example?

• When a command only works with ActiveWindow like ActiveWindow.Zoom or ActiveWindow.FreezePanes

You may access them with [], which is really beautiful, compared to the other way. Check yourself:

Try always to reference the Worksheet as well

This is probably the most common mistake in vba. Whenever you copy ranges, sometimes the worksheet is not referenced and thus VBA considers the wrong sheet the ActiveWorksheet.

• A good example of when you could be justified in using .Activate and .Select is when you want make sure that a specific Worksheet is selected for visual reasons. E.g., that your Excel would always open with the cover worksheet selected first, disregarding which which was the ActiveSheet when the file was closed.

Thus, something like the code below is absolutely OK:

• Another good example is when you need to export all sheets into one PDF file, as mentioned in this case - How to avoid select/active statements in VBA in this example?

• When a command only works with ActiveWindow like ActiveWindow.Zoom or ActiveWindow.FreezePanes

• Another good example is when you need to export all sheets in one PDF file, as mentioned in this case - How to avoid select/active statements in VBA in this example?

• Another good example is when you need to export all sheets in one PDF file, as mentioned in this case - How to avoid select/active statements in VBA in this example?

• When a command only works with ActiveWindow like ActiveWindow.Zoom or ActiveWindow.FreezePanes