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
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
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