Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sheet collection
Sub AddNames()
dim sh as Worksheet for each sh in ActiveWorkbook.worksheets sh.Cells(1,1).Value = sh.name Next End Sub -- Regards, Tom Ogilvy "john" wrote in message ... I am sure this is quite easy. I just can't find an example. I need a macro to: For each sheet in a workbook need to set sheet.cells(1,1) to sheet.name I need to do this for about 50 .xls files (All office 2000 format). So I will need to have the macro in my global.xls file Thanks for any help, John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
setup help/excel wk/sheet to record museum library collection | New Users to Excel | |||
help with data collection! | New Users to Excel | |||
Does anybody have a CD collection template | Excel Discussion (Misc queries) | |||
Is a Collection the best option? | Excel Programming | |||
Sum textboxes in a collection | Excel Programming |