Hi,

I am unable to find any information about how to, in VBA, create formulas for a number of columns in my table using the table header name instead of the std range (AB1,AC1, etc).

I have the code to change my worksheet from a range to a table and now need to enter about 9 formulas in VBA that refer to multiple columns within each formula, mostly "If" statements.

Does anyone know of a site or have examples of this?

Thanks,

Toni