Excel vba # # excel vba, excel vba excelvba
Hello_joeykang 08:53:43 2020-11-27? 17 browse

Dim arrLine, oneLine

ArrLine array for the shelves UBound (arrLine)=1
OneLine=arrLine (LBound (arrLine)) will error

Excuse me each ace to how to avoid the abnormal produce, thank you

CodePudding user response:

Ubound result is normal - 1 when the array is not return a result, not called "an empty array", you can see below, without variable is unable to return the data
No variables and null values in the local properties can be judged according to the data type, the no data type, which means can't returned data