Worksheet name

[ian.qmulus]

I'm trying to put the worksheet name in a cell in my worksheet.

I cant work out how to do it.

This doesn't work for me Cells(1, 1).Value = Worksheet.Name

Can anyone put m eright please.

Thanks

 

[Stefi]

Cells(1, 1).Value = ActiveSheet.Name
or
Cells(1, 1).Value = Worksheets("wsname").Name
or
Cells(1, 1).Value = Worksheets(1).Name

Regards,
Stefi

„[email protected]†ezt írta:

 

[ian.qmulus]

Great thanks, just had a mental block.

 

[Stefi]

You are welcome! Thanks for the feedback!
Stefi

„[email protected]†ezt írta:

 

[JE McGimpsey]

If you want a worksheet function solution:

http://www.mcgimpsey.com/excel/formulae/cell_function.html