$$Excel-Macros$$ Re: Get Numeric Values in a Column

2015-07-17 Thread Mandeep Baluja
have you got the solution by running this code ? On Friday, July 17, 2015 at 4:39:15 PM UTC+5:30, Mandeep Baluja wrote: paste this code in vba module Sub Extracterdata() Dim lr As Long lr = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row For i = 2 To lr d = Replace(Cells(i, 1).Value,

$$Excel-Macros$$ Re: Get Numeric Values in a Column

2015-07-17 Thread Mahendra Verma
It is not working, please find attached excel file of actual data. I need the output on Sheet2. On Friday, July 17, 2015 at 4:39:15 PM UTC+5:30, Mandeep Baluja wrote: paste this code in vba module Sub Extracterdata() Dim lr As Long lr = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row

$$Excel-Macros$$ Re: Get Numeric Values in a Column

2015-07-17 Thread Mandeep Baluja
check this out Check this Out. Regards, Mandeep Baluja Email :-mandeep.bal...@snapdeal.com mandeep.bal...@gmail.com https://in.linkedin.com/pub/mandeep-baluja/88/7bb/b77 https://www.facebook.com/groups/825221420889809/ -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you

$$Excel-Macros$$ Re: Get Numeric Values in a Column

2015-07-17 Thread Mahendra Verma
Thanks Mandeep... On Friday, July 17, 2015 at 5:54:42 PM UTC+5:30, Mandeep Baluja wrote: check this out Check this Out. Regards, Mandeep Baluja Email :-mandeep...@snapdeal.com javascript: mandeep...@gmail.com javascript: https://in.linkedin.com/pub/mandeep-baluja/88/7bb/b77

$$Excel-Macros$$ VLC in VBA

2015-07-17 Thread Naftali Herscovici
Hello, I am trying to create a VBA project in which I have a VLC object running a stream whose link is listed in an excel sheet. I was not yet able to find a running example online. I found examples for Visual Basic and C but not for VBA. I will not bother you with the cases I tried since

$$Excel-Macros$$ Urgent NEED: Oracle Apps Functional AR Consultant - Seattle, WA

2015-07-17 Thread MADHU-GenuineItLlc
Hi Partner, Please send resume to ma...@genuineitllc.com *ROLE**: Oracle Apps Functional AR Consultant. * *Duration : 6-12 months* *Location :Seattle, WA* *Phone interview, followed by SKYPE interview* *Immediate start* *Client needs a Functional specialist in Accounts Receivable

$$Excel-Macros$$ Re: Pls fix this error

2015-07-17 Thread Basole
Hi, pls.what is the project password ? Em sexta-feira, 17 de julho de 2015 04:07:46 UTC-3, jocky Beta escreveu: Hi All, i need help on above attached excel sheet. it always shows the error and can't work properly. Your help regarding on this will be very much appreciated Regards J.

$$Excel-Macros$$ Re: Get Numeric Values in a Column

2015-07-17 Thread Mahendra Verma
Getting below error: https://lh3.googleusercontent.com/-r3AoHmozD_E/Vai4XHaYtyI/BL0/j7e-jKtapc4/s1600/error.png -- 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: Get Numeric Values in a Column

2015-07-17 Thread Mandeep Baluja
Where is the error I am not getting the same in this sheet !!, Kindly provide the snapshot. On Friday, July 17, 2015 at 1:40:30 PM UTC+5:30, Mahendra Verma wrote: Getting below error: https://lh3.googleusercontent.com/-r3AoHmozD_E/Vai4XHaYtyI/BL0/j7e-jKtapc4/s1600/error.png --

$$Excel-Macros$$ Re: Get Numeric Values in a Column

2015-07-17 Thread Mandeep Baluja
Check this Out. Regards, Mandeep Baluja Email :-mandeep.bal...@snapdeal.com mandeep.bal...@gmail.com https://in.linkedin.com/pub/mandeep-baluja/88/7bb/b77 https://www.facebook.com/groups/825221420889809/ On Friday, July 17, 2015 at 10:09:06 AM UTC+5:30, Mahendra Verma wrote: Hi All, I

Re: $$Excel-Macros$$ Re: Get Numeric Values in a Column

2015-07-17 Thread jayaraj metta
Need to be change the file name and path when he executive on his machine On 17 Jul 2015 14:15, Mandeep Baluja rockerna...@gmail.com wrote: Where is the error I am not getting the same in this sheet !!, Kindly provide the snapshot. On Friday, July 17, 2015 at 1:40:30 PM UTC+5:30, Mahendra

$$Excel-Macros$$ Re: Get Numeric Values in a Column

2015-07-17 Thread Mandeep Baluja
Where is the snapshot ? what error you're are getting have you enabled the macro while opening ?? On Friday, July 17, 2015 at 2:58:22 PM UTC+5:30, Mahendra Verma wrote: Hi sir Please find below snapshot:

$$Excel-Macros$$ Re: Get Numeric Values in a Column

2015-07-17 Thread Mahendra Verma
Hi Sir, Getting same error. May you please share coding and process that would be helpful for us. On Friday, July 17, 2015 at 4:26:26 PM UTC+5:30, Mandeep Baluja wrote: Try to download this file On Friday, July 17, 2015 at 4:23:43 PM UTC+5:30, Mahendra Verma wrote: Please find below

$$Excel-Macros$$ Re: Get Numeric Values in a Column

2015-07-17 Thread Mahendra Verma
Please find below error getting while running: 'C:\Users\Mandeep.baluja\Downloads\Daily Shipping 16th July 2015.xlsb' could not be found. Check the spelling of the name, and verify that the file location is correct. If you are trying to open the list of most recently used files, make sure

$$Excel-Macros$$ Re: Get Numeric Values in a Column

2015-07-17 Thread Mandeep Baluja
Try to download this file On Friday, July 17, 2015 at 4:23:43 PM UTC+5:30, Mahendra Verma wrote: Please find below error getting while running: 'C:\Users\Mandeep.baluja\Downloads\Daily Shipping 16th July 2015.xlsb' could not be found. Check the spelling of the name, and verify that the

$$Excel-Macros$$ Re: Get Numeric Values in a Column

2015-07-17 Thread Mandeep Baluja
paste this code in vba module Sub Extracterdata() Dim lr As Long lr = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row For i = 2 To lr d = Replace(Cells(i, 1).Value, Campaign_P_, ) d = Replace(d, Campaign_S_, ) v = Split(d, _) lr = Range(B65536).End(xlUp).Offset(1, 0).Row Range(B