Hi
I'm not sure how to go about using the Labels control in Excel. I embed several of them in an excel worksheet and want to step through all of them but for some reason excel doesn't seem to recognise a Labels Collection. Is there a Labels Collection?
Here's what I tried to do.
First I added 5 Labels to an Excel Worksheet. Label1, Label2...to Label5
Now I tried to step through them.
Below I get Runtime error 13 'Type Mismatch'
I also tried to make an Array of Labels
For the below I get Runtime error 91 'Object Variable or With Block Variable not set'
If I place Set before the Lbls(1) I get Runtime error 13 again 'Type Mismatch'
I beleive this comes down to my fundamental understanding of Labels and how they are reference.. etc.
Any help on this would be greatly appreciated.
Thanks so much.
Danny2000
Bookmarks