A B C D E F G H I J K L M N O P Q R S T U V W X Y Z 0-9 !@$* active | api | Application | array | chart | clipboard | color | date and time | debug | Error | file | filter | find | format | log | loop | named range | PPT | Pivot Table | record | udf | workbook | wrapper Continue at Database_code 948 Steps to 6 Figures by Learning Excel-VBA and Other Skills |
| • | Function | |
| • | Array -start with "a", array function | |
| • | nested functions replace(replace(sURL, | |
| • | How to write a function to open a zip file when the file sometimes is zip and sometimes xlsb | |
| • | Function returning a value | |
| • | Mid(string,start[,end]) - string function | |
| • | vFileLen(sFile) ' udf to create an excel function to get the filelength | |
| • | functions vs. Sub | |
| • | Trim - function string removed leading a trailing characters | |
| • | Round - function | |
| • | Right(string,n) - string function | |
| • | IsError( ) - vba function | |
| • | IsEmpty( ) vba function | |
| • | Return multiple values from a function by returning a comma separated sting and parsing the results | |
| • | Len(string) - vba function | |
| • | Return a value from a function | |
| • | Trim( ) - vba function to remove leading and trailing spaces (dup) | |
| • | Application.Run - can be used to run a passed function on parameters - code in pptools - Callback_testing | |
| • | Embed a query in a function or sub | |
| • | LenB() - vba function | |
| • | WorksheetFunction.Min( ) I use application.evaluate | |
| • | API - Public Declare Function ShellExecute Lib "Shell32.dll" Alias "ShellExecuteA(ByVal hWnd As Long, ... | |
| • | WorksheetFunction.Min | |
| • | Subtotal function - excel | |
| • | Basic Excel Functions to Know | |
| • | =Randbetween(start,end) | |
| • | Indirect Function | |
| • | 16 Most Important Excel Functions to Know | |
| • | AreTheyTheSame - internet function udf to check if 2 files are the same | |
| • | ExtractData function |