I have a sheet where users can fill in columns A to M, N through RH contain formulas.
I want them to be able to click a button while any cell in the row is active that un-protects sheet, adds the row below and copies in all the formulas.
It works if they have column A active, however if its a higher column then some formulas don't get copied, however if they press the button again the next row is added with all the formulas populated correctly.
I'm trying to set the active cell to column A first before the formulas are filled in but I'm obviously getting this badly wrong. I'm far more used to using the macro recorder, trying to edit things myself is new to me.
Thank-you for any help offered.
Bookmarks