Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
flyingdoc
 
Posts: n/a
Default can I make worksheet name equal a cell

I want to make a worksheet name equal a specific cell on the worksheet - can
this be done, also is there an easy way to sort the worksheets into order

thanks

Phil

  #2   Report Post  
Paul B
 
Posts: n/a
Default

flyingdoc, you can with code, oneway to name the sheets

activesheet.name =[a1]

and to sort the sheets see this http://www.cpearson.com/excel/sortws.htm

If you need info on getting started with Macros click on the link below to
visit David McRithchie's site
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Post back if you need anymore help on this


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"flyingdoc" wrote in message
...
I want to make a worksheet name equal a specific cell on the worksheet -

can
this be done, also is there an easy way to sort the worksheets into order

thanks

Phil



  #3   Report Post  
Max
 
Posts: n/a
Default

"flyingdoc" wrote:
.. make a worksheet name equal a specific cell on the worksheet


To add-on a little for the above part ..

Try the sub below (paste in general module)
on a *back-up* copy of your file:

It loops through all worksheets (assumed identical structure)
and renames each sheet with what's in C2 [of each sheet], all at one go.

(It's assumed C2 will hold for example, text - different for each sheet,
and with no illegal characters, etc)

Sub RenameWS()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
ws.Activate
ws.Name = Range("C2").Value
Next
End Sub

Adapt the cell "C2" to suit ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----


  #4   Report Post  
JE McGimpsey
 
Posts: n/a
Default

one way:

http://www.mcgimpsey.com/excel/event...efromcell.html


In article ,
flyingdoc wrote:

I want to make a worksheet name equal a specific cell on the worksheet - can
this be done, also is there an easy way to sort the worksheets into order

thanks

Phil

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 get a cell on a page to equal the bottom most cell on dif Learning Assisstant in need of help Excel Worksheet Functions 1 May 24th 05 09:50 PM
Using a cell reference to refernce worksheet in another work book [email protected] Excel Worksheet Functions 5 January 6th 05 07:26 PM
make a cell empty based on condition mpierre Charts and Charting in Excel 2 December 29th 04 02:01 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 08:16 PM
name of another worksheet in cell for reference Tom A Johnson Excel Worksheet Functions 2 November 12th 04 12:28 AM


All times are GMT +1. The time now is 11:04 AM.

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"