DenandreH44
New Member
- Joined
- Mar 13, 2022
- Messages
- 4
- Office Version
- 365
- Platform
- MacOS
Hi there,
I'm working on some vba classwork exercises and hoping someone can point me in the direction to fix an error im facing.
The problem is below:
I've written the below code:
When i run this sub, im met with "Application-defined or object-defined error" - can someone please help me understand what this means and how i can address it?
Cheers
I'm working on some vba classwork exercises and hoping someone can point me in the direction to fix an error im facing.
The problem is below:
I've written the below code:
VBA Code:
Sub q8()
Dim array1() As Variant
array1() = Range("A24:A33")
Dim array2(0 To 9, 0) As Integer
For i = 0 To 9
array2(i, 0) = array1(i + 1, 1)
Next i
Range("B24:B33") = array2
End Sub
When i run this sub, im met with "Application-defined or object-defined error" - can someone please help me understand what this means and how i can address it?
Cheers