Hi,

I have what I hope is a simple problem.

I have written a macro that puts a load of Excel functions in a workbook. Now my problem is that when the workbook first opens one particular cell shows "#Name?" However, if I select the cell, click in the formula bar and hit enter then I get the result I am expecting.

I've made sure that all the references in the formula already exist higher in the code, so I was wondering if there are any known problems I could be hitting.

Unfortunately I can't post the workbook because of what it contains, and I can't recreate the problem in a simplified version.

Many thanks