79482490

Date: 2025-03-04 01:44:34
Score: 3.5
Natty:
Report link

I'm facing same issues as yours, now have been fixed. As per explaining from the comment array is 2d array. you need to make it your array to 2d array.

For Each myCell In Rng
 ReDim Preserve arr(i,1)
 arr(i,1) = myCell
 i = i + 1
Next myCell
.Range("H10").Resize(UBound(arr, 1),1).Value = arr
Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Me too answer (2.5): I'm facing same issue
  • Low reputation (1):
Posted by: Beans