| 1. | FindLastRow() |
| 2. | Delay n - delay for n seconds to wait or correct timing issue |
| 3. | RunProgram file - Opens website, file, etc. |
| 4. | DispYN( text) |
| 5. | PasteValues |
| 6. | Convert a column number to a letter - ColumnLetter( ) |
| 7. | FindDataCol("data",lRow) |
| 8. | FindLastCol(row) |
| 9. | cl(n) - columnLetter shorter version |
| 10. | GetUniqueValueCount(col#,header Row) |
| 11. | diffs(key1Col,sCols,key2Col,sCols2,startRow) |
| 12. | Align_on_key(key1Col,range1,key2Col,range2, |
| 13. | IsLatestFile() |
| 14. | GetFileName() |
| 15. | GetFileSuffix() |
| 16. | OpenFileAndLoadToWB() |
| 17. | If dispyn() then |
| 18. | FindDataCol(sLookup,lRow) |
| 19. | DeleteSheet "name" |
| 20. | Stop_it |
| 21. | End_it |
| 22. | FindDups |
| 23. | GetColLetter(sField,lHeaderRow ) - returns the Letter where sField is in the lHeaderRow |
| 24. | GetUniqueValueCount(col,lHeaderRow) |
| 25. | CreatePivot |
| 26. | GetLastCellAddress() - selection.specialcells(xlCelTypeLastCell).Address |
| 27. | GetUsedCells - get last cell get last row, last col and return row * col |
| 28. | ColumLetter( ) |
| 30. | CreateSheet "name" |
| 31. | CountValue(sField,sValue,lHeaderRow) ' counts the # of times sValue in the sField column |
| 32. | More |