Hi All,
im having problems using VBA to insert an IF formula,
im running a code all using relitive references and i'd like to every time the macro runs to add a new action it adds the IF formula so i dont need to drag it down all the time. I need it to insert a word depending on if an action is overdue, pending insert that word.
This is the IF formula used in excel
But i need it to change K3 depending on which row is active if thats makes sense?
so how do i get VBA to add a formula or drag it down like you would normally to change the cells to K3, K4, K5 etc?
any help would be great, thanks!
My whole sheet is designed to insert actions using a userform, whole code below if thats helpful to see what im trying to do:
Bookmarks