Cell value doesn't change

[Karen53]

Hi,

I have a named range that is pulled by individual cell into a cell on a
separate worksheet.

Here is my formula:
=IF(ISBLANK(INDEX(CAMPoolTypes,10,1)),"",(INDEX(CAMPoolTypes,10,1)))

Even though the value is changed in CAMPoolTypes, 10, 1, my cell value on
the sheet does not change. It still containes the value it had 3 changes
ago. I have checked the Named Range and it does contain the correct value.

I have run these two statements trying to clear the problem:

Application.EnableEvents = True
Application.ScreenUpdating = True

I have also closed and reopened the workbook but the problem persists.

I don't know what else to check. This has me baffled. It is showing a
value that is not there.

I just tried opening the cell and hitting enter. The value changed to the
correct value. What would have caused this if it was not one of the above
statements? If I have a hole somewhere I need to fix it but I don't know
what statement I'm looking for.

 

[Karen53]

Hi,

I have a row of these statements. I have to open them one at a time and hit
enter for them to read the NamedRange.

What's going on?

 

[Ronx]

You will get better answers by posting to an Excel forum or newsgroup -
FrontPage is for web design.