Thanks dude.

I was running the macro we created yesterday and two things happen,

1. There is an excel file open once the macro is run. I don't want to keep an open excel.
2. I get the below error, though the excel file results looks good, once the script is run. The numbers in the excel cell are in millions but the percent decrease is only -10. Is it because the number is negative. BUt again the other script when the number was -0.2 worked fine.

9
Subscript out of range