Named sheet to change Cells names

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Situation is really tricky for me, (D;E) 4 in one peace, and i need it to be
named as my sheet but not fully, Sheet name is T 060_esik (and "esik" part
needs transport into cell D;E4) is it possible?

I guess i explained correctly! Thnx
 
Let's assume that your sheetname hastwo parts separated by an underscore.
The following UDF will return the part following that underscore:

Function sname(r As Range)
Application.Volatile
sname = Split(r.Parent.Name, "_")(1)
End Function

So if the sheetname is qwerty_asdf
=sname(A1)
will display:
asdf
 
DAMn... sorry but i dont get it.. is that macro? And whats UDF =)

Function sname(r As Range)
Application.Volatile
sname = Split(r.Parent.Name, "_")(1)
End Function

Where should i add this?
 
Skrapik said:
DAMn... sorry but i dont get it.. is that macro? And whats UDF =)
Click to expand...

Think UDF = User Defined Function

To implement GS' UDF, try these steps:

Copy the UDF from GS' post
Press Alt+F11 to go to VBE
Click Insert > Module
Right-click > paste into the code window (the empty space on the right)

Press Alt+Q to get back to Excel

In Excel, in a sheet named as, say: My_Gosh
place in say B1: =sname(A1)
B1 will return: Gosh


---
 
Back
Top