Kassie, It is already ticked as default, havn't been sucsessful.

I might try the VB out,

Thanks

kassie wrote:
Click on Tools|Options, select the Edit tab, and make sure that Extend List
formats and Formulas is ticked. As you go down, this will automatically
extend your formulas