Once you open the sheet and enable macros, you can use function:
=WorksheetsNo()
To get total number of sheets in that workbook
And use function:
=WorksheetName(1)
To get sheet name for first sheet, and
Category: User-Defined f(x)s = UDF
UDF – Convert Number into text (English and Arabic)
Convert Numbers into English text and the final version of the Excel function to convert numeric values to Arabic text, (as 500 to خمسمائة). It will also enables you to add the unit you want. this was really hard in Arabic language. UDF means User-Defined-Function, which means you need to enable macros Use the English…
Read More “UDF – Convert Number into text (English and Arabic)” »
Hyperlink usage and HyperlinkOf UDF
The Hyperlink function is really powerful and yet not widely used. You can create a whole navigation system with Hyperlink fx or create a custom jump to link to take user to certain area. Of course the “Jump-to” link need other functions, like Match, Indirect and Index Here is a sample of what we can do…