worksheet name excel 2002

S

Shah Shailesh

Hi Ibo,

You can use UDF to get sheet name no matter workbook was
saved or not.

Put this code to any standard Module.

Function GetShtName()
With Application
.Volatile (True)
GetShtName = .Caller.Parent.Name
End With
End Function


In any cell (e.g. A1) type below formula to get sheet name.
=GetShtName()

Regards,
Shah Shailesh
http://members.lycos.co.uk/shahweb/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Coding Help for Beginner 0
VLOOKUP in VBA 7
Excel crashes and restarts when accessing newly created worksheet 2
VLOOKUP: Referencing worksheets whose names contain commas 7
Cancel printing a worksheet 0
Unhide sheet, copy and rename new sheets from list, rehide sheet 8
Code to format cells on several worksheets 2
referencing multiple worksheets in macro 2

Top