Dim x As Variant
Dim b As Variant
x = Array()
b = x
my point here is I want to transfer an array with ubound(-1). but it throws error when I'm passing x to b. Can you help explain how I can sort this? is this code "x = Array()" correct?
Thank you.
According to this MSDN page the cause of the error lies with the August 2019 Windows updates. There is a link to the Update Catalog if you scroll down the page and KBs are listed for various Windows versions. I've applied the fix for Win7 x64 and ...=Array() thankfully works again as before.
It depends on how are you creating the empty array. Is this what you are trying?
Option Explicit
Sub Sample()
Dim x As Variant
Dim b As Variant
Dim MyArray() As String
MyArray = Split("")
x = MyArray()
b = x
Debug.Print LBound(MyArray)
Debug.Print UBound(MyArray)
Debug.Print "-------"
Debug.Print LBound(x)
Debug.Print UBound(x)
Debug.Print "-------"
Debug.Print LBound(b)
Debug.Print UBound(b)
End Sub
Output
0
-1
-------
0
-1
-------
0
-1
