I have to produce labels, varying in size/shape (and number) on
"LabelSheet" and fill them with the contents of the active row on
"DataSheet". Explanation: UserForm pops up "Would you like the labels
at this time?", Yes, another UserForm pops up "Click on Entry (Row)
you want your label created from and then click OK" (is this bit
possible?). User clicks anywhere on Row, Row becomes ActiveRow. Then
on "LabelSheet" (which is hidden at this point) all the labels get
populated with the stuff in the ActiveRow on the "DataSheet" (copied,
not moved), "DataSheet" gets hidden and then "LabelSheet" is shown for
user to print. I should add, some labels only get one Cell Value
while other labels get more than one Cell Value, but if it makes it
easier I could design the labels so that one Cell Value on "DataSheet"
equals one Cell Value on "LabelSheet". I do hope someone out there
knows the answer, as I simply haven't got a clue!!! and all help will
be very much appreciated. BTW, merge fields is NOT an option! :-)