$$Excel-Macros$$ formula for compound interest

2015-09-19 Thread Rajesh Agarwal
Rs. 1/- rate of interest 12% compound half yearly, quartly, monthly for the period of 1. 15 months 2. 267 days -- *Rajesh Kumar Agarwal* *9811063001* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of

Re: $$Excel-Macros$$ formula for compound interest

2015-09-19 Thread Abhishek Jain
http://www.excel-easy.com/examples/compound-interest.html On Sat, Sep 19, 2015 at 11:29 AM, Rajesh Agarwal wrote: > Rs. 1/- > rate of interest 12% > compound half yearly, quartly, monthly for the period of > 1. 15 months > 2. 267 days > > -- > *Rajesh Kumar

$$Excel-Macros$$ MSG: Code execution has been interrupted

2015-09-19 Thread Pravin Gunjal
Hi, I am getting an above mentioned error message while running any macro on my computer, while the same macro could run in other computer. Could you please help me out on this. Thanks, Regards Pravin Gunjal. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

$$Excel-Macros$$ How to replace "0"s with column header values

2015-09-19 Thread N .williams
Hello I would like to know if its possible to use a macro or forumula to replace every "0" with the header cell value and list each one by student eg Student B: Q107, Q108, Q110 Many thanks for your help Nyree English_Group *Q101* *Q102* *Q103* *Q104* *Q105* *Q106* *Q107* *Q108* *Q109*

Re: $$Excel-Macros$$ Replace cell value "0" to header cell

2015-09-19 Thread nyree
Hello Abhishek That's pefect! Thank you so much for your quick response Regards Nyree On 19-Sep-15 2:20 PM, Abhishek Jain wrote: Please see attached HTH, Abhishek On Sat, Sep 19, 2015 at 5:31 PM, N .williams > wrote: Hello

Re: $$Excel-Macros$$ Error While Running Any Macro - Code execution has been interrupted

2015-09-19 Thread Abhishek Jain
See if this helps - http://www.maheshsubramaniya.com/article/fix-for-code-execution-has-been-interrupted-in-excel-vba-macros.html On Sat, Sep 19, 2015 at 3:04 PM, Pravin Gunjal wrote: > Hi, Can anyone help me on this subject? > > On Saturday, September 19, 2015 at 1:45:12 PM

Re: $$Excel-Macros$$ Error While Running Any Macro - Code execution has been interrupted

2015-09-19 Thread Pravin Gunjal
Thanks but it doesn't work Application.EnableCancelKey = xlDisabled On Sat, Sep 19, 2015 at 3:08 PM, Abhishek Jain wrote: > See if this helps - > > > http://www.maheshsubramaniya.com/article/fix-for-code-execution-has-been-interrupted-in-excel-vba-macros.html > > On Sat,

$$Excel-Macros$$ Replace cell value "0" to header cell

2015-09-19 Thread N .williams
Hello I would like to know if its possible to use a macro or forumula to replace every "0" with the header cell value and list each one by student eg Student B: Q107, Q108, Q110 Many thanks for your help Nyree English_Group *Q101* *Q102* *Q103* *Q104* *Q105* *Q106* *Q107* *Q108* *Q109* *Q110*

Re: $$Excel-Macros$$ Replace cell value "0" to header cell

2015-09-19 Thread Abhishek Jain
Please see attached HTH, Abhishek On Sat, Sep 19, 2015 at 5:31 PM, N .williams wrote: > Hello > I would like to know if its possible to use a macro or forumula to replace > every "0" with the header cell value and list each one by student > eg Student B: Q107, Q108,

$$Excel-Macros$$ Error While Running Any Macro - Code execution has been interrupted

2015-09-19 Thread Pravin Gunjal
Hi, Can anyone help me on this subject? On Saturday, September 19, 2015 at 1:45:12 PM UTC+5:30, Pravin Gunjal wrote: > > Hi, > > I am getting an above mentioned error message while running any macro on > my computer, while the same macro could run in other computer. > > Could you please help me