l1075 wrote in message ...

I don't need to go into that much depth to simplify my code.

This laziness is catching, isn't it?

I just can't get a for loop to work for this code <snip.

It works for me but then I expect that of code written by the esteemed
Tom Ogilvy:

http://groups.google.com/groups?selm....supernews.com

You should've attached to the original thread, stating what you new
requirements are.

with shtInvoice.Range in front of the Me.Controls

That doesn't adequately describe your requirements. Are your controls
now on a worksheet? If so, there is no Controls collection for a
worksheet so you have to create your own collection... oops, I forgot,
you don't like writing code to simplify code!

--