Type mismatch error when creating a vba array

Either declare myArr just as a Variant, not an array, or specify the Value property of the range:

myArr = Worksheets("Sheet1").Range("A8:E" & rw).Value

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top