Open smf723 opened 3 years ago
In the example change the cell assignments from:
Sheets("example").Range(Cells(1, 1), Cells(Parsed("values").Count, 3)) = Values
to:
With Sheets("example") .Range(.Cells(1, 1), .Cells(Parsed("values").Count, 3)) = Values End With
This eliminates the issue if the current sheet is different than "example".
In the example change the cell assignments from:
Sheets("example").Range(Cells(1, 1), Cells(Parsed("values").Count, 3)) = Values
to:
With Sheets("example") .Range(.Cells(1, 1), .Cells(Parsed("values").Count, 3)) = Values End With
This eliminates the issue if the current sheet is different than "example".