Quote Originally Posted by Djblois
Also, many places I add many column headings, can I add them all with an array? and if I can would it be quicker?

[vba]Range("A1").FormulaR1C1 = "Whse Region"
Range("B1").FormulaR1C1 = "Equiv Code"
Range("C1").FormulaR1C1 = "Product"
Range("D1").FormulaR1C1 = "On-Order FYI"
Range("E1").FormulaR1C1 = "Inventory Available"
Range("F1").FormulaR1C1 = "In Transfer"[/vba]
[vba]

Range("A1:F1").Value = Array("Whse Region", "Equiv Code", "Product", "On-Order FYI", "Inventory Available", "In Transfer")

[/vba]