How to work with errors in visual basic

[Matthew Leggett]

Hi Folks I am Using Visual Basic within Excel and have encountered a problem I hope someone can help with I have a table of Bills and months ie Month1 Month2 ........ Bill 1 0 0 Bill 2 0 0 Bill 3 0 0 For each bill there is a value in the month column. Each Cell starts with a value of 0 I create a NEW worksheet ie - NEWSHEET and this passes a formula back to cell C3 on sheet Bills C3 before = 0 C3 after = NEWSHEET!L5 - showing the contents of Cell L5 ON Sheet NEWSHEET When I delete the NEWSHEET for whatever reason the value of C3 changes to this:- C3 becomes =#REF!L5 In itself this isn't a problem as I was expecting this to happen however once the cell contains =#REF!L5 I want to run a small script to look at each cell and if the value of the cell is =#REF!L5 then I want to reset the value to zero if the value of the cell isn't =#REF!L5 then I wish to leave the value alone Hope this makes sense and that someone can assist

[ChandraRam]

Look up functions IsNA, IsError... you can use those to check the cell values and modify contents if needed. HTH