Re: $$Excel-Macros$$ Formula or UDF to do Vlookup for values delimited with ]

2013-08-25 Thread prkhan56
Dear De Premor, One small request please Is it possible to amend your code to retain the ] in the output. Thanks for your time. Regards Rashid On Wednesday, August 21, 2013 11:14:57 PM UTC+4, prkhan56 wrote: Thanks De Premor, Your code works on any sheet. Regards Rashid Khan On Wednesday,

Re: $$Excel-Macros$$ Is there a way to insert images into a specific cell?

2013-08-25 Thread Prince
No Chaya i dont think there is any way to do this with hyperlinks. On Wednesday, August 21, 2013 12:33:39 PM UTC+5:30, Chaya Cooper wrote: Eugene, I need to display the images inline. Is there a way to do that with hyperlinks? On Wed, Aug 21, 2013 at 12:18 AM, Eugene Bernard

Re: $$Excel-Macros$$ Formula or UDF to do Vlookup for values delimited with ]

2013-08-25 Thread De Premor
Try this code Function LookForCode(Str As String, Data As Range, _ Colx As Integer, Optional Delim As String = ], _ Optional RemoveDelimiter As Boolean = False) Dim Kode, Tmp As String For Each Kode In Split(Str, Delim) If Kode Then

$$Excel-Macros$$ listbox issue

2013-08-25 Thread pawel lupinski
Hi All,   I have quite serious problem with the list box (ActiveX). when I use it on the sheet where is placed is fine, but when I run any macro that is going to different sheets suddenly is becoming disable. in order to activate it I need to switch design mode click on list box and switch off

Re: $$Excel-Macros$$ Formula or UDF to do Vlookup for values delimited with ]

2013-08-25 Thread prkhan56
Hello De Premor, It shows only blanks. No data at all. Please check Thanks for your time once again. Rashid On Sunday, August 25, 2013 1:29:34 PM UTC+4, De Premor wrote: Try this code Function LookForCode(Str As String, Data As Range, _ Colx As Integer, Optional Delim As

Re: $$Excel-Macros$$ listbox issue

2013-08-25 Thread xlstime
can u please share the example workbooks for better understanding . Enjoy Team XLS On Sun, Aug 25, 2013 at 4:34 PM, pawel lupinski lupins...@yahoo.com wrote: Hi All, I have quite serious problem with the list box (ActiveX). when I use it on the sheet where is

$$Excel-Macros$$ Forecasting Methods using Excel

2013-08-25 Thread Prabhu Pinky
Hi Experts, Please share if you have any file for calls forecasting. Below are some methods in Forecasting which we use in daily basis. 1. Single Exponentioal method 2. Double Exponential Method 3. Winters Additive method 4. Winters Multiplicative method Am working in WFM Team, currently we do

Re: $$Excel-Macros$$ listbox issue

2013-08-25 Thread Bé Trần Văn
*Please Upload the file. * 2013/8/25 xlstime xlst...@gmail.com can u please share the example workbooks for better understanding . Enjoy Team XLS On Sun, Aug 25, 2013 at 4:34 PM, pawel lupinski lupins...@yahoo.comwrote: Hi All, I have quite serious

$$Excel-Macros$$ Re: Introduce Yourself !!

2013-08-25 Thread Ishani Rajpal
Hello Everybody, This is Ishani here. I am a commerce graduate with an MBA in finance. I have joined this forum to participate in excel discussions and also to learn from it. On Saturday, June 9, 2012 12:51:59 AM UTC+5:30, Ayush Jain wrote: Hey all new and current posters, Welcome to

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

2013-08-25 Thread vba
Hey Welcome !!! Keep rokinnn.. Cheerz. On 25 Aug 2013 23:36, Ishani Rajpal isharaj...@gmail.com wrote: Hello Everybody, This is Ishani here. I am a commerce graduate with an MBA in finance. I have joined this forum to participate in excel discussions and also to learn from it. On

Re: $$Excel-Macros$$ Is there a way to insert images into a specific cell?

2013-08-25 Thread Chaya Cooper
bé trần văn - Unfortunately that didn't work because when I tried sorting the rows the images aren't moving accordingly :-( On Sunday, August 25, 2013 11:28:17 AM UTC-4, bé trần văn wrote: *You try this. * 2013/8/25 Prince prince...@gmail.com javascript: No Chaya i dont think there is any

$$Excel-Macros$$ Delete File Contents

2013-08-25 Thread pankajinfo
Dear Gurus, I want to create a excel file with Date limit. Like in a file there are some contents(Graphs, Dashboards Etc) with 3 sheets. What i wants is after a time period like 31-Aug13 it gets expired and no one can open it or if someone opens after 31-Aug-13 it will delete all the file