From the course: Excel: Macros and VBA for Beginners

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

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

Start my 1-month free trial

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