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

2016-09-03 Thread 'ravinder negi' via MS EXCEL AND VBA MACROS
On Saturday, September 3, 2016 11:42 AM, GENIUS wrote: THANK YOU VERY MUCH MR GAURAV DEVRANI AND ALSO THANKS FOR MR XLS S for a new way of doing the same. -- 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

Re: $$Excel-Macros$$ Sumif multiple column

2016-08-25 Thread 'ravinder negi' via MS EXCEL AND VBA MACROS
PFA On Friday, August 26, 2016 10:52 AM, Deepak Rawat wrote: Hi, Need sumif function to sum multiple columns sample excel attached. Regards,Deepak -- 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 for

Re: $$Excel-Macros$$ Rename all sheets of one excel file in single shot with different names

2016-08-24 Thread 'ravinder negi' via MS EXCEL AND VBA MACROS
PFA On Tuesday, August 23, 2016 2:35 PM, Pravin Gunjal wrote: Dear Gaurav Thanks for solution. You have created a sheet viz. Tab-Names and then used two macros based on requirement. But my worry is that in every month number of sheets are getting changed and I believe the codes can ru

Re: $$Excel-Macros$$ VBA Macro for PPT Chart objects content edit (inside)

2016-02-26 Thread 'ravinder negi' via MS EXCEL AND VBA MACROS
dim ppApp  As PowerPoint.Applicationdim ppReport   As PowerPoint.Presentationdim ppSlide  As PowerPoint.Slidedim oPPTOLEObject_Text   as object Set ppReport = ppApp.Presentations.Open("PPT Path")                    ppApp.Visible = msoTrue                    'Filling text boxes in ppt            

Re: $$Excel-Macros$$ Re: overflow error issue

2016-02-24 Thread 'ravinder negi' via MS EXCEL AND VBA MACROS
Hi Integer has as limit 32767 more than it it will show overflow error so you have to use long variable.  ThanksRavinder Negi On Wednesday, February 24, 2016 1:11 PM, Kat wrote: Hi Mandeep, I don't know how to use VLookUp function for my situation. I was wondering whether would you m

Re: $$Excel-Macros$$ removes the jpeg extension

2016-02-06 Thread 'ravinder negi' via MS EXCEL AND VBA MACROS
On Saturday, February 6, 2016 7:51 PM, GENIUS wrote: FIRST Thank you very much for your reply, consideration and code actually I dont know a lot about macros, may be 10% out of 100%,  so please do it for me the code i sent to your with the file is not typed by me but taken from somewh

Re: $$Excel-Macros$$ Excel function for TC_Name with Priority.

2015-12-12 Thread 'ravinder negi' via MS EXCEL AND VBA MACROS
Hi, please use below formula =IF(IFERROR(SEARCH("_H_",A2),0)>0,"High",IF(IFERROR(SEARCH("_M",A2),0),"Medium","Low"))  or attached file On Saturday, December 12, 2015 5:08 AM, Sairam Prasath wrote: Hi All,I need the excel formula for the following. | TC_Name | Priority | | TC_H_001 | Hig