Copying formula to proper column in excel

Hi all,
I have already wrote the VBA code which is adding the a new column to the right of the last column.What I want to do that is to copy the formula of last column and the range should change with suitable column.
For example I am using that formula on the last column.
=$A$186+SUMPRODUCT($B$14:$B$160;C14:C160)+SUMIF($C14:C160;"<1")
And I need to change "C" parts of the code.
Thanks!!

Hello,

It has been reported that you have crossposted your question in other forum(s) and it seems to have been resolved. Can you please supply links to those other threads here.

Please read here to understand why we ask: http://www.excelguru.ca/content.php?184