VBA to put formula into cell

Hello,

In a effort you keep you guys challenged. And obviously improve my VBA writing skills...I really appreciate all the responses I have had up date.

I am trying to add a formula to a cell, after a macro has run..

The formula is going into Cell B49 on worksheet "Front Sheet"

The formula is "=if('Not Resolved'!A2=Logged!$B$1, 'Not Resolved'!A2,0)

I cant put the formula prior to macro running as it is insert additional column to some a sheet, which then changes the above cell reference in the formula

Basically I am trying to do is get the unique reference for rows of data so the Vlookup (which is in another cell


I think this is a long winded way to do what I really want ... but as they say its size chunks all part of my learning.


Many Thanks In advance

Debs