Question 16: What is option base in vba 2013?
Question 17: How to return multiple values in vba function?
Question 18: How to recalculate all formula once values are updated?
Question 19: What is excel object model?
Question 20: How to manipulate a protected sheet using VBA?
Answer: If a sheet is protected we can't manipulate the sheet with VBA. In order to do that , you have to first un protect the sheet using a VBA command, do manipulation as required, then protect the sheet with same password.