Re: $$Excel-Macros$$ Macro not working

2016-09-09 Thread GENIUS
Thanks brother that's great -- 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 this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please

Re: $$Excel-Macros$$ Macro not working

2016-09-09 Thread Learner Excel
Try enclosed one -- On Fri, Sep 9, 2016 at 9:37 AM, GENIUS wrote: > working perfectly, thank you very much for your help > > one more question, if I have figures in column A as shown in the sheet > and I want to take the 17% in column B of the amount of column A as shown > in the attachment t

Re: $$Excel-Macros$$ Macro not working

2016-09-08 Thread GENIUS
working perfectly, thank you very much for your help one more question, if I have figures in column A as shown in the sheet and I want to take the 17% in column B of the amount of column A as shown in the attachment then how do I automate this task whenever i put a figure in column A and run

Re: $$Excel-Macros$$ Macro not working

2016-09-08 Thread Learner Excel
Opps you have register incorrect data type against variable j, data type should be string [image: Inline image 1] -- On Thu, Sep 8, 2016 at 10:01 PM, GENIUS wrote: > > Sir >>> >> Thanks for your follow up, I enable which you have mentioned in the last >> mail but there is another message pleas

Re: $$Excel-Macros$$ Macro not working

2016-09-08 Thread Learner Excel
Attachment missing -- On Thu, Sep 8, 2016 at 9:59 PM, GENIUS wrote: > Sir >> > Thanks for your follow up, I enable which you have mentioned in the last > mail but there is another message please see the attachment > > right now I have three version of excel i.e. 2007,2010 & 2013, I opened > th

Re: $$Excel-Macros$$ Macro not working

2016-09-08 Thread GENIUS
> > Sir > Thanks for your follow up, I enable which you have mentioned in the last mail but there is another message please see the attachment right now I have three version of excel i.e. 2007,2010 & 2013, I opened the file in excel 2010 and I also have Microsoft outlook 2010 -- Are you =EXP(

Re: $$Excel-Macros$$ Macro not working

2016-09-06 Thread Learner Excel
Brother, you have to add Outlook reference as well [image: Inline image 1] -- On Tue, Sep 6, 2016 at 9:18 AM, GENIUS wrote: > Sir > > I'm waiting for your reply very anxiously > > -- > 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 offici

Re: $$Excel-Macros$$ Macro not working

2016-09-05 Thread GENIUS
Sir I'm waiting for your reply very anxiously -- 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 this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread t

Re: $$Excel-Macros$$ Macro not working

2016-09-03 Thread Learner Excel
You need to add "Microsoft Outlook 14.0 Object Library" in references -- On Sat, Sep 3, 2016 at 10:10 PM, Izhar wrote: > > Please see the question in the attachment > > -- > 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

$$Excel-Macros$$ Macro not working

2016-09-03 Thread Izhar
Please see the question in the attachment -- 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 this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles

Re: $$Excel-Macros$$ Macro Not working in shared Work Book

2012-10-23 Thread Paul Schreiner
n, To all the people you can, As long as ever you can.” - John Wesley - From: Viswanathan Yoganathan To: "excel-macros@googlegroups.com" Sent: Tue, October 23, 2012 3:24:34 PM Subject: $$Excel-Macros$$ Macro

$$Excel-Macros$$ Macro Not working in shared Work Book

2012-10-23 Thread Viswanathan Yoganathan
Hi, I am getting the below error if I run the macro in a shared and protected workbook. 'Run time Error 1004 unprotect method of worksheet class failed' Do we have any solution to overcome. Thanks, Vishwa. "CONFIDENTIALITY NOTICE: This message and any attachment are confidential and may also