Thread: Excel help Sheet Name...linking into Spreadsheet
View Single Post
Old 15-08-2005, 13:41   #11
Mike
Inactive
 
Join Date: Jan 2004
Age: 64
Posts: 2,242
Mike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful one
Re: Excel help Sheet Name...linking into Spreadsheet
Quote:
Originally Posted by Simon M
If you created a Module and add this code to it, the sheet names will appear in the first column on Sheet1.



It also creates a Macro called Sheetname that can be run to update the list if any are added or taken away.

It's basic, but does the job.
Looks good but how do you create a Module

thanks Mike
Mike is offline   Reply With Quote