LinkBack URL
About LinkBacks
I have only a very cursory understanding of VBA and I'm working in Excel 2007. Can someone please help me with a UDF that will provide me with the SHEET function as it works in the current Excel versions?
Thank you in advance
I have only a very cursory understanding of VBA and I'm working in Excel 2007. Can someone please help me with a UDF that will provide me with the SHEET function as it works in the current Excel versions?
Thank you in advance
This UDF return sheet number of active sheet
In any cell, input:PHP Code:Function SheetNum() As Integer
SheetNum = ActiveSheet.Index
End Function
=sheetNum()
Quang PT
SHEET Function
Please Login or Register to view this content.
The following function slightly better mimics the original SHEET function available in Excel since version 2013:ArtikPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks