The VBA puts that formula in for you.

Try re copy/pasting the VBA code because I made a mistake at first but I fixed it.
I just tried the code I pasted up top and it is working for me.