Selecting a range and then working with Selection is what the recorder writes. Working with the range directly is faster, does not move the user's cursor, and works on sheets that are not active.

Code

' slow
Range("A1").Select
Selection.Value = 1
' better
Range("A1").Value = 1

• Drop Select

  ' slow Range("A1").Select Selection.Value = 1 ' better Range("A1").Value = 1 → The same result without the Select

  Delete Select/Selection pairs.

• Other sheets

  Worksheets("Data").Range("A1").Value = 1 → Writes to a sheet that is not active

  No Activate needed.

• Format without selecting

  With Worksheets("Data").Range("A1:C10") .Font.Bold = True .Interior.Color = vbYellow End With → Formats without selecting

  With blocks replace Select.

• Search recorded code for .Select and .Activate and remove them one by one.
• Copy Destination:= and direct Value assignment avoid selection for copying.
• Only user-facing utilities should read the selection.

• Select fails on hidden sheets and on sheets that are not active.
• Selecting scrolls the user's view around.