Is it possible to assign values to array without looping? VBA

Question

I'm a bit new to VBA and don't understand how do I assign specific values into array, not the range. I'm trying to do something like this:

Dim toDel(8) As Integer
Set toDel() = Array(1, 3, 5, 6, 7, 8, 10, 12)

But it returns me error. So can I somehow insert a hole array into array without looping through each element? Like we do it in python just array = array

Array() is a function that returns a Variant array, so you can only assign its result to a Variant. If you had a function that returns a strongly typed integer array, you could assign that to an integer array variable, provided it was declared as a dynamic array. You should not use Set. — GSerg
– GSerg, Commented Jul 20, 2021 at 19:58

Gary's Student · Accepted Answer · 2021-07-20 19:45:51Z

3

Consider:

Option Explicit
Sub whatever()
    Dim toDel As Variant
    toDel = Array(1, 3, 5, 6, 7, 8, 10, 12)
End Sub

answered Jul 20, 2021 at 19:45

Gary's Student

96.9k10 gold badges66 silver badges104 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Is it possible to assign values to array without looping? VBA

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related