Hi All
I have been looking/trying various bits of code to insert a row on a large protected sheet. I have also been recoring various stages, but cant get the result I am after and think I might be overcomplicating metters.
Large Excel sheet with A:Z and 1-100 hidden, full of calculations. The sheet is essentially a company productivity report combining downloaded data with user input and calculating top 10 etc for various criteria.
I am looking to find a way of safely inserting rows at a user defined point keeping the linear calculations intact and updating the reference number.
If anyone can give me a good starting point, it would be much appreciated.
I have been looking/trying various bits of code to insert a row on a large protected sheet. I have also been recoring various stages, but cant get the result I am after and think I might be overcomplicating metters.
Large Excel sheet with A:Z and 1-100 hidden, full of calculations. The sheet is essentially a company productivity report combining downloaded data with user input and calculating top 10 etc for various criteria.
I am looking to find a way of safely inserting rows at a user defined point keeping the linear calculations intact and updating the reference number.
If anyone can give me a good starting point, it would be much appreciated.
