Dim MyArray() as Variant
and then using
[vba]MyArray = Sheets("xyz").Cells(r,c).Resize(dr,dc)[/vba]
will cause a 'Can't assign to Array' error.
The fix? Just remove the parantheses from the Dim statement. In Windows, VBA works with either form.
Dim MyArray() as Variant
and then using
[vba]MyArray = Sheets("xyz").Cells(r,c).Resize(dr,dc)[/vba]
will cause a 'Can't assign to Array' error.
The fix? Just remove the parantheses from the Dim statement. In Windows, VBA works with either form.
Posting Permissions
Reply With Quote