Menu

Sheet name = cell value

Search this Thread

Prev

Previous Post

Next Post

Next

#3

Report Post

Posted to microsoft.public.excel.programming

(PeteCresswell) (PeteCresswell) is offline

(PeteCresswell) is offline

external usenet poster

Posts: 139

Default

Sheet name = cell value

Per :
Hi everyone. Is there a way for vba to run through all sheets in a
workbook, and set each sheet name to the value in cell B1 of that
sheet? Thanks!

Yes, but be aware that Excel imposes some limitations on a sheet's name.

Something like 31 chars max, and not including certain characters.

Try setting a sheet's name to something that's 40 chars long and the resulting
Error$ that it throws will list the special characters.
--
PeteCresswell

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 do I copying data from a cell on sheet to a diff cell/sheet	Bowldiva120	Excel Worksheet Functions	1	March 21st 10 11:25 PM
copy a sum in cell on sheet 1 (not formula) to cell on sheet 2	John	Excel Worksheet Functions	1	March 2nd 09 12:01 AM
copy a sum in cell on sheet 1 (not formula) to cell on sheet 2	Eduardo	Excel Worksheet Functions	0	February 27th 09 05:19 PM
Excell:Move from any Cell Sheet 1 to any cell Sheet 2 etc.	eldo	Excel Worksheet Functions	1	August 16th 05 09:17 AM
Excel VBA (?!)-refer to a cell on Sheet to left of X, based on criteria on Sheet X	tempjones	Excel Programming	2	June 7th 04 09:48 PM

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

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement