>Naomi
>To what property of the column do I assign the calc to?
>

>.columns(x).WHAT??? = (apInvItems.qtyOrdered - apInvItems.qtyInvoiced)
>

>Thanks, vince
>
>PS, like your message, add to that list of virtues: Poor culinary habits

.columns(x).ControlSource = "(apInvItems.qtyOrdered - apInvItems.qtyInvoiced)"

Not sure I got the joke about poor culinary habits.

BTW, I'm not even sure you need (), it may even work without them.