From the course: Excel: Macros and VBA for Beginners (2021)

Unlock the full course today

Join today to access over 24,200 courses taught by industry experts.

Warnings about VBA and macros: There is no undo

Warnings about VBA and macros: There is no undo - Microsoft Excel Tutorial

From the course: Excel: Macros and VBA for Beginners (2021)

Start my 1-month free trial Buy for my team

Warnings about VBA and macros: There is no undo

“

- The biggest deal about working with macros and VBA, there is no undo. To point out the significance of this, I've got some data, about attendance over two weeks. I'mma open a sheet and record a macro because there is something that I have to do every time I get this workbook, and it'd be easier to have a macro do it for me. Here we go. New sheet, I'm going to click this icon to start a macro running. I'm going to name this days, I'm going to use the shortcut key, control, shift D. And then click okay. And these are the steps that I'm tired of doing, go to C2, I'm going to zoom in, Sunday, enter, go here, drag down to Saturday. auto widen and the column, boost the font up to 18, make the font bold and blue. Auto widen the column again. Those are all of the steps, now let's stop the macro, I'm going to go down here, stop recording, beautiful. So I'm going to click…

Contents