Posted to microsoft.public.excel.worksheet.functions

Gary''s Student Gary''s Student is offline

external usenet poster

Posts: 11,058

naming tabs

Sub missive()
s = Array("jan", "feb", "mar", "apr", "may", "jun", "jul", "aug", "sep",
"oct", "nov", "dec")
For i = 1 To 12
Sheets(i).Name = s(i - 1) & " 2008"
Next
End Sub

mind the text wrapping!!
--
Gary''s Student - gsnu200759

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
Naming tabs	Mike	Excel Worksheet Functions	5	November 27th 07 05:04 PM
Naming Worksheet tabs	Scott@CW	Excel Discussion (Misc queries)	11	August 2nd 07 08:36 AM
Naming Tabs	ebro	Excel Discussion (Misc queries)	3	July 13th 06 11:07 PM
naming tabs	Jeff	Excel Worksheet Functions	8	February 6th 06 04:41 AM
Naming Sheets Tabs	Cgbilliar	Excel Worksheet Functions	2	November 5th 04 05:21 PM

All times are GMT +1. The time now is 10:05 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us