After a VBA sub, #VALUE! will show in cells with formula

[Saintor]

But if I edit manually those cells manually just with F2 + ENTER, without modifying anything, then #VALUE! will go away and the proper value will appear.

Is there an instruction that I could use to prevent this to happen?

There is no error in the function. And the sub doesn't refer to the cell with the function.

Please Login or Register  to view this content.

The sub retrieves the lead time which I place in a separate cell $B$8. Then the function above uses this cell as the LT1 input value.

[davesexcel]

You may have to provide more information.

[Saintor]

After CTRL+ALT+F9 or if I use in the debug window Application.CalculateFull, it refreshes itself correcty.

Adding instruction Application.CalculateFull in the code after retrieving the variable doesn't work.

[rorya]

What's the sub?

[Saintor]

It is just to retrieve some data form a SQL server via ADO. The formula goes crazy right after

ActiveCell.Offset(3, 0) = rst!LeadTime

I made sure that the format of the cell is number.

[Saintor]

I finally removed the formula tied to cells and used only VBA to calculated their value.