Usually, source data sheets are either not formatted or they're
pre-formatted. Thus the target sheets would be pre-formatted for the
expected data, or the data/range formatted as desired after populating
the respective cells. Ultimately, it's up to you or your client how the
target sheet looks!<g

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion