Those are just a couple of minor changes, but they’ll change the behavior of the macro. The next thing we’ll do is in the AutoFill destination change A1 through G1 which is going across the row, to A1 through A7, which goes down the A column.Ĭhange it in two places: here and also here. We’ll change the day name to the number 1. The first thing we need to change is the first instruction ActiveCell.FormulaR1C1 = “Sunday”. I am going to change the instructions in this copy of the macro "FillDaysRelativeC". Let’s rename the original macro "FillDaysRelativeR" for rows, and rename the copy "FillDaysRelativeC" for columns, since these two macros can’t have the same name. I’ll click here at the end, press Enter, and then Paste what I just copied. I’ll select all of this text, starting with Sub and ending with End Sub, and copy it by pressing Ctrl+C. It’s called a Sub or Sub Routine and its name, "FillDaysRelative", is followed by a pair of parenthesis. You can also create macros from scratch in this editor. Visual Basic is the programming language that macros are recorded in. This opens the macro in a special text editor called the Visual Basic Editor. Here is the last macro I recorded, "FillDaysRelative". Let’s edit the macro to see what its instructions look like.Ĭlick the Macros button. We could record a new macro, or edit it manually. We’ll change it, so it enters the days a numbers instead of names, and arrange them vertically in a column, instead of horizontally in a row. Let’s pick up where we left off with our macro: "FillDaysRelative", which enters the days of the week in cells across a row.
#Sprint layout edit macros microsoft how to#
In the first video, we saw how to record a macro, and how and why to turn on Use Relative References, so the macro behaves the way we want.
0 kommentar(er)
