Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 5th 06, 09:51 PM posted to microsoft.public.excel.misc
PDS
 
Posts: n/a
Default How can I make the names for Sheet tabs a reference to a cell?

I want the tab names in my workbook to be cell references. If it is a Macro
function I will need the formula.

  #2   Report Post  
Old May 5th 06, 11:19 PM posted to microsoft.public.excel.misc
saziz
 
Posts: n/a
Default How can I make the names for Sheet tabs a reference to a cell?


PDS,

This formula gets your sheet name in cell A1:

=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)

Syed


--
saziz
------------------------------------------------------------------------
saziz's Profile: http://www.excelforum.com/member.php...fo&userid=6350
View this thread: http://www.excelforum.com/showthread...hreadid=539416

  #3   Report Post  
Old May 5th 06, 11:20 PM posted to microsoft.public.excel.misc
Gary''s Student
 
Posts: n/a
Default How can I make the names for Sheet tabs a reference to a cell?

This may help:

Sub Macro1()
Sheets(1).Select
Sheets(1).Name = Cells(1, 1).Value
End Sub

This tiny macro will set the name of the tab equal to the value in cell A1,
for the first tab..

It can be easily modified to loop over all tabs, use different cells, etc.
--
Gary''s Student


"PDS" wrote:

I want the tab names in my workbook to be cell references. If it is a Macro
function I will need the formula.



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
How to have a variable cell reference across sheets? Shane Gibson Excel Discussion (Misc queries) 3 March 8th 06 11:10 PM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM
Flexible Cell Reference Brandt Excel Discussion (Misc queries) 5 June 2nd 05 10:23 PM
how to make cell address reference increment? jacko Excel Worksheet Functions 3 June 1st 05 05:33 PM
Maintaining cell reference after sorting GRITS Excel Discussion (Misc queries) 1 December 2nd 04 09:30 PM


All times are GMT +1. The time now is 02:32 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017