Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 4
Default Rename Sheet from a cell value

1) Is it possible via a macro To take the value of say Cell (A1) and rename the current sheet you have focus on.


Thanks

garry


  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,872
Default Rename Sheet from a cell value

Hi,

Am Tue, 26 Nov 2013 09:30:11 -0800 (PST) schrieb Garry:

1) Is it possible via a macro To take the value of say Cell (A1) and rename the current sheet you have focus on.


try:
ActiveSheet.Name = Range("A1")


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 4
Default Rename Sheet from a cell value

On Tuesday, 26 November 2013 17:41:42 UTC, Claus Busch wrote:
Hi,



Am Tue, 26 Nov 2013 09:30:11 -0800 (PST) schrieb Garry:



1) Is it possible via a macro To take the value of say Cell (A1) and rename the current sheet you have focus on.




try:

ActiveSheet.Name = Range("A1")





Regards

Claus B.

--

Win XP PRof SP2 / Vista Ultimate SP2

Office 2003 SP2 /2007 Ultimate SP2


Im sorry, Could you please tell me where this goes in the sheet. Sorry Im a bit thick.
Garry
  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,872
Default Rename Sheet from a cell value

Hi,

Am Tue, 26 Nov 2013 10:51:12 -0800 (PST) schrieb Garry:

Im sorry, Could you please tell me where this goes in the sheet.

Press Alt+F11, insert a standard module and paste the code into the code
window:

Sub Test()
ActiveSheet.Name = Range("A1")
End Sub

Back on your sheet you can run the nacro "Test" to name the sheet.


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Rename Sheet using Cell Reference RDana Excel Worksheet Functions 4 July 2nd 07 07:54 PM
Rename selected (highlighted) sheet with cell contents of sheets in cell A1 [email protected] Excel Programming 2 December 15th 06 09:41 AM
How do I automatically rename a sheet with the contents of a cell. michaelspearin Excel Discussion (Misc queries) 3 December 3rd 04 10:27 PM
Add sheet and rename with cell contents Rudy Woltner Excel Programming 4 April 22nd 04 10:44 AM
Macro to rename all worksheets with cell value in each sheet Max Excel Programming 1 July 11th 03 10:58 AM


All times are GMT +1. The time now is 04:51 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"