I've modified you're code and adapted it into Indonesian , Many thanks for your help, your site realy enlight me and your work realy help me in my daily job. Number To Teks in Indonesian (Bahasa Indonesia) Send med your code by mail using the address at the bottom of this page and I will make it available for download with credits to you.īilly S.C Ticoalu from Tolitoli, Indonesia wrote ( 03:41:16 CET): The code you posted was truncated and incomplete due to limitations of this feedback system. Re: Number To Teks in Indonesian (Bahasa Indonesia) Lieu quoc dat from Viet nam wrote ( 11:20:12 CET): Application.Calculation = xlCalculationAutomatic) Application.Calculation = xlCalculationManual)Īfter your code has finished remember to reset Calculation and ScreenUpdating (usually not necessary in Excel): declaring all variables with their proper data type (e.g. I assume your problem is related to running macros. You can use this function when you don't want to use the database functionality in Excel. This workbook contains a custom function that shows how you can return an array with the unique values from a range. A worksheet function that returns an array with unique values.You will also find a function that counts the matches according to the position in the range. The function counts matches regardless of the position in the range. This workbook uses a custom function to return the count of equal values in two different ranges. You may also calculate with negative time values. This workbook demonstrates how you can calculate with time values (hours, minutes). The example will only work in Excel97 because of the use of a UserForm, but can easily be converted to Excel5/95. If the value you are looking for occurs more than once, the function displays a dialogbox that lets you select which value you want the function to return. If you look up numbers/text from lists/databases that contains several duplicate values, you will have use for this function. If you are using an English edition of Excel you'll have little use for this workbook. from English to German if you are using a German edition of Excel. It is also possible to translate from English function names to the local function name, e.g. from German to English if you are using a German edition of Excel. This workbook can translate worksheet function names from the local language used in Excel to the English function names, e.g.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |