Re: $$Excel-Macros$$ Information

2014-12-02 Thread Vaibhav Joshi
Hi There is no team buddy.. 80-90% queries are not a new, i have already answered it in past or its simple logic! Also i am not from IT field & i have not obtained formal programming training.. so every new query makes me more curious to learn new thing! what all knowledge i have gained / am gai

$$Excel-Macros$$ Information

2014-12-02 Thread Mandeep Baluja
This question is for vabz, Mostly the queries answered by vaibhav Are you working with a team or you are answering the queries by yourself only ??? without getting help of someone, because you're the only efficient programmer in vba here.And I am new in this field.Can you recommend the best book

Re: $$Excel-Macros$$ move or copy define name range one sheet to another sheet vba code

2014-12-02 Thread Ashish Kumar
Hi Amar, PFA Change the Data Range according to your requirement. Don't paste the data in this Sheet. If you want to Copy range from AAA sheet to BBB, then Paste your Data in AAA and Save it on Desktop and Create a blank Sheet on Desktop named BBB. Regards Ashish -- Are you =EXP(E:RT) or =NO

Re: $$Excel-Macros$$ VBA : How to create array dynamically

2014-12-02 Thread Vaibhav Joshi
share an example sheet for better idea... atleast 5 instances + *I did not do this for you. God is here working through me for you.* On Tue, Dec 2, 2014 at 4:41 PM, Mahesh Patil wrote: > Hi Paul, > Thans for reply. > I am looking to create variable at runtime. > > Ex: > Sub test() > Dim X

Re: $$Excel-Macros$$ VBA : How to create array dynamically

2014-12-02 Thread Paul Schreiner
You're not going to be able to do that. Can I ask why? I cannot imagine how you could create a variable that you don't know the name for, then use it later in a macro. If you can provide some context and explain what you're trying to accomplish, perhaps I can help. Paul -

Re: $$Excel-Macros$$ Re: move or copy define name range one sheet to another sheet vba code

2014-12-02 Thread amar takale
Dear Mandeep brother,thanks alot.Its perfect. On Tue, Dec 2, 2014 at 5:14 PM, Mandeep Baluja wrote: > PFA !!! > > > Sub MovedRange() > > Dim WKB1 As Workbook > Dim WKB2 As Workbook > Dim NM As Name > > Set WKB1 = Workbooks("AAA.xls") 'change the source workbook name > accordingly

$$Excel-Macros$$ Re: move or copy define name range one sheet to another sheet vba code

2014-12-02 Thread Mandeep Baluja
PFA !!! Sub MovedRange() Dim WKB1 As Workbook Dim WKB2 As Workbook Dim NM As Name Set WKB1 = Workbooks("AAA.xls") 'change the source workbook name accordingly Set WKB2 = Workbooks("BBB.xls") 'change the destination workbook name accordingly For Each NM In W

Re: $$Excel-Macros$$ VBA : How to create array dynamically

2014-12-02 Thread Mahesh Patil
Hi Paul, Thans for reply. I am looking to create variable at runtime. Ex: Sub test() Dim X as range X =Activeworkbook.worksheet("sheet1").range("A1:A100") For each i in X Dim i as integer Next i End sub 'This code wont work ' I need to create 100 variables 'having name mentioned in each 'cell

Re: $$Excel-Macros$$ move or copy define name range one sheet to another sheet vba code

2014-12-02 Thread Ashish Kumar
Hi Amar, If it's not useful then share your requirement sheet with required output. Regards Ashish -- 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

Re: $$Excel-Macros$$ Re: Concatenate with VBA

2014-12-02 Thread Vaibhav Joshi
cheers buddy!! It will help you most... + *I did not do this for you. God is here working through me for you.* On Tue, Dec 2, 2014 at 3:33 PM, Mandeep Baluja wrote: > Thanks Vabz > > On Tuesday, December 2, 2014 3:02:29 PM UTC+5:30, Mandeep Baluja wrote: >> >> Hello, >> >> I need your help

$$Excel-Macros$$ Re: Concatenate with VBA

2014-12-02 Thread Mandeep Baluja
Thanks Vabz On Tuesday, December 2, 2014 3:02:29 PM UTC+5:30, Mandeep Baluja wrote: > > Hello, > > I need your help to acheive something with the help of regular expression > or by any way in vba. what i want is to concateneate a range of cells if > its cell is having duplicates then it should

Re: $$Excel-Macros$$ Concatenate with VBA

2014-12-02 Thread Vaibhav Joshi
hi check this.. http://stackoverflow.com/questions/22382416/in-excel-2010-how-could-i-remove-duplicates-and-concatenate-values-within-a-cel Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Dec 2, 2014 at 3:02 PM, Mandeep Baluja wrote: > Hello, > > I

$$Excel-Macros$$ Concatenate with VBA

2014-12-02 Thread Mandeep Baluja
Hello, I need your help to acheive something with the help of regular expression or by any way in vba. what i want is to concateneate a range of cells if its cell is having duplicates then it should be concatenate only one time. Regards, Mandeep -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in

Re: $$Excel-Macros$$ move or copy define name range one sheet to another sheet vba code

2014-12-02 Thread amar takale
ashish this is not useful for me On Tue, Dec 2, 2014 at 2:01 PM, Ashish Kumar wrote: > Hi Amar, > > Check this :- > > SubJect - Copy paste data from one sheet to another based on click > > Query Raised in Group - 28th Nov, 2014. > > Status - Resolved. > > > > Regards > Ashish > > -- > Are you =EX

Re: $$Excel-Macros$$ move or copy define name range one sheet to another sheet vba code

2014-12-02 Thread Vaibhav Joshi
Hi Amar, Long time... check this sheet with macro...Press Alt + F8 to run macro... syntax is .. Names("*DefinedName*").RefersToRange.Cells.Copy Sheets("*sheet2*").Range(" *a1*") wherein *DefinedName *is your name for which data to be copied.. *shee2* is sheet name to which data tobe co

$$Excel-Macros$$ Re: move or copy define name range one sheet to another sheet vba code

2014-12-02 Thread Mandeep Baluja
Sub copysheet2() ActiveSheet.Range(Range_name).Copy Sheets(NewsheetName).Range("A1").PasteSpecial End Sub Regards, Mandeep Baluja Excel Specialist. https://www.linkedin.com/profile/view?id=312532939 https://www.facebook.com/VBAEXCELSQL?ref=hl On Tuesday, December 2, 2014 1:01:46 PM UTC+5:30,

Re: $$Excel-Macros$$ move or copy define name range one sheet to another sheet vba code

2014-12-02 Thread Ashish Kumar
Hi Amar, Check this :- SubJect - Copy paste data from one sheet to another based on click Query Raised in Group - 28th Nov, 2014. Status - Resolved. Regards Ashish -- 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 pag