Hi,
1. Yes, the named range was named listsheets after all the sheets were created. I have created worksheet with INDEX list of all the worksheets. Because they still will be being added with time. So I wanted to track them there.
2. Yes, I have saved the workbook after all these operations.
But the formula still returns 0's,
Another problem is whenever I re-open the file my listsheets is gone from the Name Manager. I have to do it over again. Could this be a problem?