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

Where Am I?

You are currently viewing the archives for September, 2012 at RheXenoR.