Hi,
I have a listbox which I am trying to populate with an array.
the line of code I am using to do this is
My sub is stalling on this line though, with error message
This seems like an odd error message to me since
am I missing anything here? Perhaps I'm referencing the array wrong. When I rest my cursor over that line in debug mode the comment that pops up shows that the error refers to the array reference.
I'm sure it's possible the problem may lie in another part of my code but I thought I'd try this first
Any help would be much appreciated.
Thanks for your time.
Straws
I have a listbox which I am trying to populate with an array.
the line of code I am using to do this is
Code:
listbox1.Column() = d()
Run-time error 91: Object variable or With block variable not set
This seems like an odd error message to me since
- a - it's not in a With block
b - I have dimensioned the array, and have filled it.
am I missing anything here? Perhaps I'm referencing the array wrong. When I rest my cursor over that line in debug mode the comment that pops up shows that the error refers to the array reference.
I'm sure it's possible the problem may lie in another part of my code but I thought I'd try this first
Any help would be much appreciated.
Thanks for your time.
Straws