Hi,

I have some code that has been working but now it seems to 'Hang up' and
won't change.

I have a cell that compares to another cell and if it has a value pulls in
the value of that cell.

=IF(ISBLANK(INDEX(CAMPoolTypes,6,1)),"",(INDEX(CAMPoolTypes,6,1)))

'Campooltypes, 6,1' is now blank but it continues to show it's old value.

I thought perhaps my screenupdating was still off for some reason so I ran
the statement: Application.ScreenUpdating = True and changed the value again
but the value pulled in did not change. I changed the value again and the
value changed. I cleared it and the value changed again as it should.

I am at a loss as to how to determine what is happening. I would appreciate
any suggestions on finding out what is causing this intermittant probem.
--
Thanks for your help.
Karen53

Try this

=IF(ISBLANK(INDEX(CAMPoolTypes,6,1)),"",CAMPoolTypes!A6)

--
If this reply was helpful, please indicate that your question has been
answered to help others find anwsers to similar questions.

www.silverbirddesigns.com

Fighting Texas Aggie Class of 2009


"Karen53" wrote:

> Hi,
>
> I have some code that has been working but now it seems to 'Hang up' and
> won't change.
>
> I have a cell that compares to another cell and if it has a value pulls in
> the value of that cell.
>
> =IF(ISBLANK(INDEX(CAMPoolTypes,6,1)),"",(INDEX(CAMPoolTypes,6,1)))
>
> 'Campooltypes, 6,1' is now blank but it continues to show it's old value.
>
> I thought perhaps my screenupdating was still off for some reason so I ran
> the statement: Application.ScreenUpdating = True and changed the value again
> but the value pulled in did not change. I changed the value again and the
> value changed. I cleared it and the value changed again as it should.
>
> I am at a loss as to how to determine what is happening. I would appreciate
> any suggestions on finding out what is causing this intermittant probem.
> --
> Thanks for your help.
> Karen53