Re: $$Excel-Macros$$ Add No of Years Specified

2015-02-10 Thread Paul Schreiner
How's this? Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley -

$$Excel-Macros$$ Add No of Years Specified

2015-02-10 Thread Hilary Lomotey
Hello Experts, i am developing a form and i need assistance with a code, i can do it with a formula but i dont like the final results because of the final output i want. Basically in sheet2, when i click on setup and i choose a start year for instance 2006 and specify the number of years for

$$Excel-Macros$$ Re: Run time error...

2015-02-10 Thread Christos Alekopoulos
Hi Michael, That works perfect thank you!!! Cheers, Christos -- 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

Re: $$Excel-Macros$$ Re: Run time error...

2015-02-10 Thread Christos Alekopoulos
Thanks Vabz but I don't want just a function that replaces any value. My post explains fully what I needed! Cheers -- 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 @

$$Excel-Macros$$ Re: Run time error...

2015-02-10 Thread michael vinoth
Welcome Christos... On Tuesday, February 10, 2015 at 4:52:30 PM UTC+5:30, Christos Alekopoulos wrote: Hi Michael, That works perfect thank you!!! Cheers, Christos -- 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

$$Excel-Macros$$ Help with excel data fill formula

2015-02-10 Thread Enock Wangila
Hi Guys, Please help me find a solution to this challenge. I need a formula that helps me fill multiple cells in a different worksheet by entering a value in a single cell in another worksheet. For instance, I have a cell with a value of 5000 in one worksheet and I need a formula to populate 9

$$Excel-Macros$$ Button click with vba

2015-02-10 Thread Mandeep Baluja
how to click this *input value=Sign in class=button type=submit button i tried many thing but unsuccesful.Regards.Mandeep * -- 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 @

$$Excel-Macros$$ Re: Button click with vba

2015-02-10 Thread Mandeep Baluja
Absolutely correct but i was using form 1 that's why it is giving error could you please let me know why 0 is used. for form. On Wednesday, February 11, 2015 at 10:20:23 AM UTC+5:30, Mandeep Baluja wrote: how to click this *input value=Sign in class=button type=submit button i tried

Re: $$Excel-Macros$$ Re: Button click with vba

2015-02-10 Thread Vaibhav Joshi
0 is for form 1, 1 for form 2 so on... if you know form name then you can use it directly... IE.document.forms(myform)(0).submit Cheers!! On Wed, Feb 11, 2015 at 12:16 PM, Mandeep Baluja rockerna...@gmail.com wrote: Absolutely correct but i was using form 1 that's why it is giving error

Re: $$Excel-Macros$$ Button click with vba

2015-02-10 Thread Vaibhav Joshi
Hi I have found very simple way to submit button, i assume you are using IE automation there is only one form on webpage: IE.document.forms(0).submit 'here IE is your InternetExplorer.Application Cheers!! On Wed, Feb 11, 2015 at 10:20 AM, Mandeep Baluja rockerna...@gmail.com wrote: how to

Re: $$Excel-Macros$$ Re: Run time error...

2015-02-10 Thread Vaibhav Joshi
Christos, you could have achieved this by following simple line too: Sub Macro1() Prompt = What is the original value you want to replace? Title = Search Value Input Search = InputBox(Prompt, Title) Prompt = What is the replacement value? Title = Search Value Input Replacement = InputBox(Prompt,

$$Excel-Macros$$ Re: Run time error...

2015-02-10 Thread Christos Alekopoulos
In fact I used a slightly different code... It finds a row with a certain value (the risk id for my case) and replace another value in the same row that I set. I hope I this code helps others as well! Thank you again for all your help and feedback!!! Sorry for the comments but I think

$$Excel-Macros$$ Information Required

2015-02-10 Thread Rakesh kumar
Hi Friends, My company wants to me learn SAS, so that i need some information about the same. Can anyone tell me about SAS software. why we use SAS, what is difference beetween Excel and SaS. If anyone have a Live example of SAS, i mean the dataset, summary or any other reports which created