Hi,
The syntax is:
ActiveSheet.Name = Range("Sheet1!C4")
This line renames the active sheet to whatever is in Sheet1!C4
Change the details to suit your requirements.
Regards - Dave
Date: Mon, 11 Jan 2010 18:08:49 +0530
Subject: Re: $$Excel-Macros$$ Using macro move sheets from one work book to
another work book
From: darsh...@gmail.com
To: excel-macros@googlegroups.com
Does any one has macro to rename the tabs
I have list of names around 50 in one sheet and i want to rename the tab
according. sometimes i may have less also.
Thanks and Regards,
Darshan
On Mon, Jan 11, 2010 at 11:30 AM, grlinks-karthik <grli...@gmail.com> wrote:
I need to copy the sheets from one work book to another work book, can any one
help is urgent
I have to work book name called “destination.xls” and “source.xls”,
destination.xls work book contain two sheets name called “sheet1” and
“sheet2” ( source.xls workbook contain only one sheet name called “IT” , these
two sheets copied and move to Source.xls workbook next to “IT” sheet, I need
the Macro for it
But some conditions are there.
1. Macro should be Run while source.xls work book open ( destination
should not be open)
2. Both work books will be in different Locations
3. Moved sheets should be hidden (only programmer can see the sheets)
4. Moved sheets name should be always “sheet1” and “sheet2”
5. Suppose “sheet1” and “sheet2” already exists in source.xls work book
then exists sheets should be deleted and moved sheets (destination.xls work
book sheets) should be replaced
Friends your people can able to understand the above, please help me it very
urgent
regards
Grlinks-karthik
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us in TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,500 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
--
Dar_ing Darsh..!!!!
_________________________________________________________________
Search for properties that match your lifestyle! Start searching NOW!
http://clk.atdmt.com/NMN/go/157631292/direct/01/--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us in TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,500 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
