rohit_raghu:

Well, when you look at the spreadsheet, do the formulas you want actually make it into the workbook? Do the cells contain the data you want? Are the values anything other than zero? You provide no information and only a fragment of your code, so all I can do is ask questions. Hopefully, one or more will prove useful.

When debugging, be sure to understand the problem. Then question all your assumptions. The hard part is to recognize all the assumptions you're making.

...roboticus

When your only tool is a hammer, all problems look like your thumb.