WorksheetName and WorksheetsNo UDFs
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 …
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 …
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 …