Populating Formula in a table column

I am simulating a problem that I have with another file with lot of macros and code etc.  That file was working on every machine, except mine.  

I have a table with three columns. 

Table Name : MonthTable

Columns : Month1, Month2, Month3

I am trying to populate a formula in Month2 using the formula below.

Range("MonthTable[[#Headers],[Month1]]").Offset(1, 1).Formula = "=1"

I am expecting it to populate the entire column. But it is populating the formula in one cell only.    Are there any special table settings I need to check or options to make it work on my machine ?