79418564

Date: 2025-02-06 16:02:06
Score: 2
Natty:
Report link

One option is to do it in one line:

Sheets("Sheet1").Range("A1:Z9").copy Sheets("Sheet2").Range("A1")

In general, working with the Active Sheet (using Range("a1") without specifying the sheet) or using the active Selection can lead to problems since the starting state is not known or controlled.

Reasons:
  • Low length (0.5):
  • No code block (0.5):
  • Low reputation (1):
Posted by: Bill Cressman