#VALUE error

[GRCArizona]

Hi -

hopefully an easy solution to this:

I've got a 'Data Validation' cell and when the end user makes a selection from the drop down, the chart will auto-refresh. However, a few cells are not updating after the selection in the drop down is made. The cell values go right to the error "#VALUE". If I manually go into the cell's formula and hit enter, they work correctly. The formula in the cell(s) that aren't working are a custom function (VLOOKUPnth value).

I have tried the following VBA solutions, but they don't work:

#1 - have the macro go into the cell and re-type the formula.
#2 - Application.AutocalculateFull

Any suggestions?

Thanks GRC

 

[AlphaFrog]

In your macro, try one of these to force a recalculation.

Application.Calculate                   [color=green]'(or just Calculate) All open workbooks[/color]
Worksheets(1).Calculate                 [color=green]'A specific worksheet[/color]
Worksheets(1).Range("A1:C10").Calculate [color=green]'A specified range[/color]