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 |
| • | col variables - stores the number of a column which is retrieved via FindDataCol in case column moves (Hardcoding) | |
| • | copy modules in and finding all the syntax error | |
| • | Find Missing Data | |
| • | FindDataCol - udf - 🔝 | |
| • | FindDataCol("fieldname",row_nbr) udf | |
| • | FindDataRow("string",col_nbr) | |
| • | FindDataRowPartial(sSearch, c) as Long | |
| • | Finding the Macro being Recorded | |
| • | FindLastCol(1) - find the last column passed a row udf | |
| • | Findlastrow - udf - finds the last row in a column | |
| • | FindWorkbook(sWB) udf | |
| • | GettheVersion | |
| • | instr( ) - find a string within a string and return the offset | |
| • | lcol = Finddatacol("column header fields",1) ' avoid hardcoding by searching for a column | |
| • | Ubound(array) - finds the upper bound of an array |