Getting all of the sheet names in the sheet collection

[John]

I am sure this is very simple. But I can't find an
example.

I need to produce a macro that will put the "sheet.name"
in "sheet.cells(1,1) for each sheet in a workbook.

Any help will be greatly appreciated.

John

 

[Jonathan West]

Hi John,

This group deals with VBA in Word. For Excel questions, you will find the
experts at microsoft.public.excel.programming