Inserting Worksheet name into a cell

[richruss]

Is there a way that Excel can display the name of the worksheet in a cell - similar to the way that the custom header/footer uses &[TAB]?

[MartinShort]

Run this macro.

Please Login or Register  to view this content.

MS

[dominicb]

Good afternoon Richruss

You could use a function if you don't fancy using VBA.

=CELL("filename")

...will do the trick.

HTH

DominicB

[MartinShort]

I like that Domenic. Does it work for worksheets as well as workbooks?

[dominicb]

Hi Martin

Thanks for your response. Unfortunately not, to answer your question. There are about a dozen different options that tell you things like the value of the top left cell in a range ("contents"), whether or not the cell is locked ("protect") and the width of a cell, rounded to the nearest whole number ("width"). I don't know if any of these would ever be of use to you, but the filename option is the only one I've ever found useful.

You probably know from programming VBA that there are hundreds of objects and interesting settings that can return values, but the only way to access most of them is through VBA (or write your own UDF). it's quite a shame really because this function could have been really beefed up allowing you to show user name, creation date, last save date, company etc etc, all of which Excel holds plus much much more.

DominicB

[MartinShort]

Hmmm - I thought you were going to say that. I couldn't see the answer in Excel's help files.

Cheers
MS