From the course: Excel: Macros in Depth (Microsoft 365)
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Streamlining macros
From the course: Excel: Macros in Depth (Microsoft 365)
Streamlining macros
- [Instructor] We're looking at the file Partial-6. And what we're see on the screen represents, you could say the culmination of what we've been doing in the previous six movies in this chapter. We initially started by planning a macro, we talked about how we would record, just partial code, and then introducing a loop structure, a do loop. Then testing the macro in step mode. We pull the data together by sorting it in another macro. We join the two macros. And now as we consider looking at the code, we can make the code be a bit more compact. This is the least important of what we do, but on the other hand, as you work with macros and you view macro code, the shorter the code is, the easier it tends to be to work with. So I'll press Alt F11, we're in the world of Visual Basic. And in this workbook Partial-6, there're two modules, Module1 has the macro that we used in the previous movie, remember we actually took one macro…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.