Re: $$Excel-Macros$$ Using macro move sheets from one work book to another work book

2010-01-12 Thread grlinks-karthik
can i get the macro for my request On Mon, Jan 11, 2010 at 11:30 AM, grlinks-karthik 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 con

RE: $$Excel-Macros$$ Using macro move sheets from one work book to another work book

2010-01-11 Thread Dave Bonallack
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 m

Re: $$Excel-Macros$$ Using macro move sheets from one work book to another work book

2010-01-11 Thread DARSHAN K N
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 wrote: > I need to copy the sheets from one work book to