The purpose of the project is to edit and refactor the Stock Market Dataset with VBA code and determine whether refactoring the code successfully made the VBA script run faster. The goal is to make the code more efficient— less steps, using less memory, or improving the logic of the code to make it easier for users to read.
. The code refactoring should be performed in small steps to improve the code.
. long procedure may contain the same line of code in several locations, opportunity - change the logic to eliminate the duplicate lines.
. A complex unstructured code is better to split in several functions. A clean and well-organized code is always easy to understand, change and maintain.