$$Excel-Macros$$ Resource Development Program for Freshers with job

2015-12-24 Thread iTech Analytics
We are one of the Resource Development Center located in Bangalore. We conduct Resource Development Program on Analytic tools and technologies for Freshers and Professionals based on the real time requirements to match the current skill needs of the Corporates. We train on below Tools and

$$Excel-Macros$$ Re: Excel Formula Returning Different Value if User Clicked Checkbox

2015-12-24 Thread mortgageprogrammer
Suresh: This is perfect!!! Thank you Sorry for the delayed thank you, M.P. On Thursday, December 17, 2015 at 1:59:30 AM UTC-5, Suresh Kumar B wrote: > Hi, > > Herewith i have attached the solved excel. > > If you have any questions, Please let me know. > > *Thanks & Regards,* > *Suresh

Re: $$Excel-Macros$$ Remove all existing macros on certain date

2015-12-24 Thread Pravin Gunjal
Hi any update on this plz. On Dec 23, 2015 7:45 PM, "Pravin Gunjal" wrote: > Hi Expert, > > Can i get a macro which can remove all existing macros from a file on > certain date.. > > Kindly share the same. Thanks. > > Regards > Pravin Gunjal > > -- > Are you =EXP(E:RT) or

$$Excel-Macros$$ Re: Paragraph - Split Up - Excel

2015-12-24 Thread Mandeep Baluja
Run this code !! Mandeep baluja Sub SplitPara() Dim lr As Long: lr = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row Dim j As Long: j = 0 For Nrow = 2 To lr arr = Split(Trim(Range("A" & Nrow).Value), vbLf) ReDim arr1(LBound(arr) To UBound(arr)) For lb = LBound(arr) To UBound(arr) If

Re: $$Excel-Macros$$ Remove all existing macros on certain date

2015-12-24 Thread jayaraj metta
If you want to delete the module then use below code 'Author #Jayaraju Metta Sub vbcomponents() Dim vbcom as Object Set vbcom=application.VBE.activeVBProject.Vbcomponents vbcom.remove Vbcomponent:=_ vbcom.item("Module1") End sub If you find any difficulties please let me know On Dec 23, 2015 7:45

Re: $$Excel-Macros$$ Remove all existing macros on certain date

2015-12-24 Thread jayaraj metta
"Existing macro on certain Date" Can you please elaborate above line with some live example. Share some files with the same On Dec 23, 2015 7:45 PM, "Pravin Gunjal" wrote: > Hi Expert, > > Can i get a macro which can remove all existing macros from a file on > certain date..

Re: $$Excel-Macros$$ Remove all existing macros on certain date

2015-12-24 Thread Pravin Gunjal
Thanks but where is the date On Dec 24, 2015 3:59 PM, "jayaraj metta" wrote: > If you want to delete the module then use below code > 'Author #Jayaraju Metta > Sub vbcomponents() > Dim vbcom as Object > Set vbcom=application.VBE.activeVBProject.Vbcomponents >

Re: $$Excel-Macros$$ Remove all existing macros on certain date

2015-12-24 Thread Pravin Gunjal
Yes exactly. On specific date. On Dec 24, 2015 3:53 PM, "jayaraj metta" wrote: > Hello Pravin Gunjal, > Do you want to delete modules in a project using a macro? > Can you please elaborate it ? > On Dec 23, 2015 7:45 PM, "Pravin Gunjal" wrote: > >> Hi

Re: $$Excel-Macros$$ Remove all existing macros on certain date

2015-12-24 Thread jayaraj metta
Hello Pravin Gunjal, Do you want to delete modules in a project using a macro? Can you please elaborate it ? On Dec 23, 2015 7:45 PM, "Pravin Gunjal" wrote: > Hi Expert, > > Can i get a macro which can remove all existing macros from a file on > certain date.. > > Kindly share

Re: $$Excel-Macros$$ Remove all existing macros on certain date

2015-12-24 Thread Pravin Gunjal
Hi I have some macro in file and suppose i want to remove them after 4 days. So is there any such macro available which can work on my requirements. Thanks Pravin Gunjal. On Dec 24, 2015 5:53 PM, "jayaraj metta" wrote: > "Existing macro on certain Date" > > Can you