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 |
• | Excel Features to Know to move from Beginner to Expert | |
• | Move columns on a report | |
• | RemoveCanceled - Removes rows with a status of canceled - udf | |
• | Remove filtered data but keep filters | |
• | Trim - function string removed leading a trailing characters | |
• | col variables - stores the number of a column which is retrieved via FindDataCol in case column moves (Hardcoding) | |
• | Trim( ) - vba function to remove leading and trailing spaces (dup) | |
• | Down1 - sub to move activecell down 1 row sc | |
• | RemoveLastComma | |
• | RemoveSQLComments - udf | |
• | Right1 - udf - move activecell 1 to the right | |
• | rs.MoveNext | |
• | FixEmail - Take an email address with < > and remove this | |
• | RemoveRangeNames - Removes ones with errors | |
• | Remove people from email who are no longer at your company |