Complex VBA Excel - Best Practice (KISS)- Visual Diagrams-Wireframes or Recommendations

Frustrated quickly when getting 40 lines of VBA down to learn it can be written In 2 lines going a different route.  Recommendations for the best practices on CLEANIEST way possible for Excel VBA ...