Help

[Aaron]

This is a real simple one, that for some reason I can't figure out. I need a cell in my worksheet to have a formula that is the worksheet name. The formula =CELL("Filename") gets me too much info. All I need is the Sheet name. Any help would be appreciated. -asa

 

[lenze]

Check out the MoreFunctions add-in available here.
http://longre.free.fr/english/index.html
It contains afunction called SheetName that will do what you want.

This can also be done with code. There are numerous previous postings of this method.

 

[Jim North]

Function SName()
Application.Volatile
SName = ActiveSheet.Name
End Function

 

[Aaron]

On 2002-08-20 14:00, Jim North wrote:
Function SName()
Application.Volatile
SName = ActiveSheet.Name
End Function

Jim -
I tried inserting the code above, and I get nothing. I am doing something wrong? I inserted the code in the VB Editor on the VBA Project window under ThisWorkbook. Is that right? thx in advance

 

[lenze]

If you want to use Jim's code, it is a UDF. You need to put it ina regular module. VB editor, Insert Module.

Best: Put it in a module in your Personal.xls workbook so it will always be available.

 

[Aaron]

On 2002-08-20 14:52, lenze wrote:
If you want to use Jim's code, it is a UDF. You need to put it ina regular module. VB editor, Insert Module.

Best: Put it in a module in your Personal.xls workbook so it will always be available.

OK, I must be an idiot. I put it in a module, and still get nothing. I apologize for my ignorance.

 

[Aaron]

On 2002-08-20 14:58, Aaron wrote:

On 2002-08-20 14:52, lenze wrote:
If you want to use Jim's code, it is a UDF. You need to put it ina regular module. VB editor, Insert Module.

Best: Put it in a module in your Personal.xls workbook so it will always be available.

OK, I must be an idiot. I put it in a module, and still get nothing. I apologize for my ignorance.

OK I am still an idiot, but i did get it to work. I apologize for the confusion. Have I posted how great this board is? Its great. Thanks guys & gals.