Hello,
My question is: What's the proper way to determine if a variable holds an array?
I have a function that returns either an empty variable or an array.
If the function does not return to my variable an array, and I treat the variable as an array, then it obviously throws an error.
So my question is, is there a way to determine if a variable is an array without throwing an error?
If not, is there a way to code an if/then statement to see if an error is thrown, maybe something like below?
Or do i have to just assume the variable is an array and use the "On Error" statement every time?
If there is no way getting around using the "On Error" statement, what's the proper way to set this particular scenario up. I try to use as little GoTo statements in my code as possible because I feel they junk it up. Is that a foolish concern?
The thing is, I'm trying to learn to code as cleanly as possible. But this scenario always leads me to some ugly solution.
Thanks for any and all help!
Bookmarks