VBA does not correct the notation of functions and variables that are located in a .xlam

These produce exactly the same result.

Sheets(1).Range("A1").Copy Sheets(2).Range("A2")

You will not see the above when it executes.

Sheets(1).Activeate
Range("A1").Select
Selection.Copy
Sheets(2).Acivate
Range("A2").Select
ActiveSheet.Paste

You will see all the action for the above code although it might just appear as fliker onthe monitor. Direct coding as in the first example shows very little if any updating on the monitor screen. But the Select and Activate method of coding does show the updates on screen step by step.