Macros
- Getting started
- Writing macros
- Adding custom functions
- Debugging
- Converting VBA macros
- Samples
- Write data to worksheet cell
- Change cell background color
- Change cell font color
- Make cell font bold
- Merge cell range
- Unmerge cell range
- Set column width
- Format range as a table
- Add chart
- Highlight duplicates
- Next blank row
- Insert text
- Currency exchange rates
- Import CSV or TXT data
- Recalculate worksheet values
- Unhide all rows and columns
- Remove shapes from slides
- Insert unique id
- Complete address information
- Replace words in document
- Add comments and change cell colors in spreadsheet