Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 26th 13, 05:30 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2009
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  
Old November 26th 13, 05:41 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,689
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  
Old November 26th 13, 06:51 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2009
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  
Old November 26th 13, 06:53 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,689
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 08:41 AM
How do I automatically rename a sheet with the contents of a cell. michaelspearin Excel Discussion (Misc queries) 3 December 3rd 04 09: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 10:15 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017