Cell value doesn't change

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.
--
Thanks for your help.
Karen53

Karen53
Wed Oct 24 13:58:01 PDT 2007

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?
--
Thanks for your help.
Karen53


"Karen53" wrote:

> 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.
> --
> Thanks for your help.
> Karen53

Ronx
Thu Oct 25 01:19:22 PDT 2007

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

--
Ron Symonds - Microsoft MVP (FrontPage)
Reply only to group - emails will be deleted unread.

http://www.rxs-enterprises.org/fp




"Karen53" <Karen53@discussions.microsoft.com> wrote in message
news:A131C07D-CC00-4B73-8F15-741C72FB4847@microsoft.com:

> 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.
> --
> Thanks for your help.
> Karen53