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

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

Regards,
Stefi

€� ezt Ã*rta:

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

Great thanks, just had a mental block.

You are welcome! Thanks for the feedback!
Stefi

€� ezt Ã*rta:

Great thanks, just had a mental block.

If you want a worksheet function solution:

http://www.mcgimpsey.com/excel/formu..._function.html



In article .com,
" wrote:

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