By using expertatexcel.com you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

Become an Σxpert at Σxcel.com

 


Standard VBA/Excel (15 of 1182)

(Clear Filter = *Move*)

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