Comments by lgmanuel (Top 2 by date)

lgmanuel 12-Aug-14 19:06pm View

Thanks for the reply,

Yes, exactly. i already have the average per date. now i'm not sure how to average the whole column.

The link you have provided seems to point only google main page and no article.

lgmanuel 31-Jul-14 18:56pm View

Hi Valery,

Thanks for the insight. i will note that link.

I tried your suggestion to add 'Const xlValues = -4163' at the top of the code as you said. i'm sure not what i am doing wrong but when Excel pops out after running the script. No Data is populated. not sure how to troubleshoot as it does not show any error.

tried to place the code anywhere before the code that saves the data to Excel, but no lucks T_T. I hope you can enlighten me more. Thanks