VBA to put formula into cell

Debs269 Posts 21 Registration date Monday October 15, 2012 Status Member Last seen August 18, 2016 - Apr 24, 2014 at 08:26 AM
 Blocked Profile - Apr 24, 2014 at 06:26 PM

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


1 response

Blocked Profile
Apr 24, 2014 at 06:26 PM
Debs, you never cease to amaze!

There is a command to update the worksheet, like .calculate, or .fullcalculate. Try this one though:
ActiveSheet.EnableCalculation = False
ActiveSheet.EnableCalculation = True

Let us know!