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