Hi,
im really struggling to get VBA to run and insert a forumla into a cell when running not calculate it in VBA as it needs to calculat every time the sheet is opened.

im trying to do:
=VLOOKUP(E3,Users,2,FALSE)
But i need to link it to active cell as the macro that is inserting it changes down a row each time.

this is what its doing but i need to take the calculation out of VBA and into excel:
ActiveCell.Offset(0, 12) = Application.WorksheetFunction.VLookup(Range("E" & ActiveCell.Row), Range("Users"), 2, False)
hope this makes sense to someone and you can help!
many thanks