Hi all,
I want to write an Excel macro to print out labels. The data source i
from another Excel file, from the current sheet I have a sampl
formatted Label, after run the macro the result is created on the nex
sheet with many labels (because labels are small so I want to print ou
many labels on one paper). Of course the content of each label i
different but same format.
The problem is how to get the format from sample range (cell width
height, font...) and apply to the new out put on the next sheet.

Thanks for any helps.
Toan

--
tttoa
-----------------------------------------------------------------------
tttoan's Profile: http://www.excelforum.com/member.php...fo&userid=2374
View this thread: http://www.excelforum.com/showthread.php?threadid=37411