Cell Value doesn't change

[Karen53]

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.

 

[Texas Aggie]

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