Excel – Workbook Path, Sheet Name (Excel Function)

10/09/2012 § Leave a comment

=WB_Path()

Function WB_Path() As String

WB_Path = ThisWorkbook.FullName
End Function

__________________________________

=sheetname(A1)

Function SheetName(rAnyCell)
Application.Volatile
SheetName = rAnyCell.Parent.Name
End Function

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

What’s this?

You are currently reading Excel – Workbook Path, Sheet Name (Excel Function) at RheXenoR.

meta

%d bloggers like this: