When switching between programming languages, it can be a pain to remember the syntax.
To help, here is a “cheat sheet” of syntax for VBA for Excel.
In addition, there are two handy samples of VBA code:
- Identifying the worksheet’s lowest non-empty ROW (into a variable called “last_row”) and right-most non-empty COLUMN (into a variable called “last_col”)
- Writing all the values of a worksheet’s column A (each value on a new row) as a text file to the active directory