The macro that existed in Excel was deleted and after it had worked by “Record of a new macro”, th [...]…