Ok.., that was fun!!
I reworked your example closer to how I might go if keeping to your
design context.
<trivia
I have my own proprietary invoice template[s] that my invoicing and
point of sale apps use. There are 4 styles with or without auto item
entry, no logo and with logo. Item lists are on the same sheet outside
the Print_Area.
</trivia
The revisions include list layouts, overall formatting, lots of name
defs, a new style def for field headers, extensive formula revisions,
and some instructional comments. Lots for you to digest!<bg
Look for "Invoice1_v3.xlsx" here...
https://app.box.com/s/23yqum8auvzx17h04u4f
--
Garry
Free usenet access at
http://www.eternal-september.org
Classic
VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb.general.discussion