Your attached file was not saved as an xlsm so your code is not there. You can do most of the regular formulas in VBA by typing out WorksheetFunction. An example is below
Its great that you are learning how to code. Another resource you can use is the macro recorder. While this bloats things quite a bit you can get the function syntax for something like inserting a column just by recording it and then looking at the code.

Let me know if this is any help at all or if you just a code snippet.

Thanks