My rule of thumb, if it will take you the same amount of time or more to write code vs doing the repetitive task the number of iterations it must be done to completion manually, you don't write code. You exhaust all other possible options as invalid and then write code.įor 2, this is a bit more gray. When a task is repetitive over a lengthy period of time and can be automated with VBA to save time.When no built in feature can accomplish a task feasibly.VBA should be used only in 1 of 2 circumstances: The difference between a good VBA programmer and a great one? I agree with this, but not the stuff after. The most important Excel skill is learning when NOT to use it and when another tool would be more appropriate. Recent ClippyPoint Milestones !Ĭongratulations and thank you to these contributors DateĪ community since MaDownload the official /r/Excel Add-in to convert Excel cells into a table that can be posted using reddit's markdown. Include a screenshot, use the tableit website, or use the ExcelToReddit converter (courtesy of u/tirlibibi17) to present your data. NOTE: For VBA, you can select code in your VBA window, press Tab, then copy and paste that into your post or comment. To keep Reddit from mangling your formulas and other code, display it using inline-code or put it in a code-block This will award the user a ClippyPoint and change the post's flair to solved. OPs can (and should) reply to any solutions with: Solution Verified Only text posts are accepted you can have images in Text posts.
Use the appropriate flair for non-questions.Post titles must be specific to your problem.
0 kommentar(er)
