79271183

Date: 2024-12-11 09:41:46
Score: 1
Natty:
Report link

Most probable it can happen if the active sheet is not a worksheet or no active sheet yet.

In this code fragment

 With wksNew
    Columns("A:A").Select

the Columns member is applied to the active sheet not to wksNew. May be the dot is omitted here?

 With wksNew
    .Columns("A:A").Select
Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Ends in question mark (2):
  • High reputation (-1):
Posted by: rotabor