Alright. No idea how to answer my own question but I did find
different much much easier way of doing it. (you ever notice that whe
you try to find an answer to a problem you usually make it much muc
harder than it has to be)

For some reason my re-calculate values in the Tools-Options menu wa
set to manual... now it updates it (I was wondering too why it neve
updated when i changed a cell reference) Anyway it's good now.

Thanks

--
Message posted from http://www.ExcelForum.com