Putting the current SheetName into a Cell

[OdinsDream]

How can I set a cell's value equal to the name of the sheet that it is on?


I'm aware of ActiveSheet.Name in VB, but is there a method I can use that doesn't require a macro to run?

[Ivan F Moala]

On 2002-05-20 09:17, OdinsDream wrote:
How can I set a cell's value equal to the name of the sheet that it is on?


I'm aware of ActiveSheet.Name in VB, but is there a method I can use that doesn't require a macro to run?

I believe this has been covered before;
A search would reveal a number of solutions
One of which is;
=MID(CELL("filename",A1),FIND("]",CELL("filename"),1)+1,255)

[s-o-s]

On 2002-05-20 09:17, OdinsDream wrote:
How can I set a cell's value equal to the name of the sheet that it is on?


I'm aware of ActiveSheet.Name in VB, but is there a method I can use that doesn't require a macro to run?

Hi,
Are you opposed to User Defined Functions?

If not then create the following and you can just enter the formula into spreadsheet as below

=SheetName()

Function SheetName()
    SheetName = ActiveSheet.Name
End Function

[sann0638]

I love the way by the time you have posted, two people have beaten you to it! This board is great

using:
=cell(A1,"filename")

and doing some cropping should get you there

_________________
As ever, I expect there's a better way.

Regards,
Mike

[ This Message was edited by: sann0638 on 2002-05-20 09:25 ]