copy formulas left

"Cells" is a property of the Range Object. It's parameters are row and column.

"Offset" is also a property, which steps away from a given range.

In this code we are saying "Move one column right from ActiveCell. Copy that cell. Paste it in the ActiveCell."

If you selected A1, running the macro would copy B1 into A1.