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 |
| • | Array -start with "a", array function | |
| • | reference value in an array aSuffixes(i) | |
| • | InArray(array,value) - determines if value is in the array - udf | |
| • | Ubound(array) - finds the upper bound of an array | |
| • | LBound(array) - returns the lower bound of an array | |
| • | Split(string,"value") - converts string into an array | |
| • | Sheets(Array("sheet1","sheet2").copy | |
| • | InArray(array, the_value) | |
| • | LoadArray 🔝 | |
| • | LoadArray(workbookname, Sheetname, header) 🔝 | |
| • | ByteArrayToString - internet | |
| • | stringtobytearray - internet | |
| • | PivotFields("field_name").Subtotals = Array(False, False, ...) | |
| • | IsArrayEmpty - udf | |
| • | Activesheet.Shapes.Range(Array("Button 1")).Select | |
| • | Selection.OnAction = "TOC1.AddTocSheet" ' Select the shape first via ActiveSheet.Shapes.Range(Array("Button 1")).Select | |
| • | Array(string, string, ....) - Converts a list of strings to an array | |
| • | Subscript out of range | |
| • | Large Arrays - Interview Question | |
| • | Arrays vs. Collections |