Hi All,
back again to pick your brains, need help.
what i have is a userform with 42 (yes 42) labels. (actually 84)
I want to name each of these labels after 42 cells in the excel file, i have another 42 labels on the sheet that i want to have equal values for each label name.
here is what i attempted
feel free to point out my issue but its the line with
which is failing
any help is appreciated.
i was using the
but it began naming the last 42 labels after blank values......
anyway again all help appreciated.
many thanks
Dave
Bookmarks