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
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
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
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
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
-
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
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
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
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
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
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
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
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
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
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
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,
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
17 matches
Mail list logo