Is it possible to shorten recorded macro?

Question

I am not a programmer, but I am trying to learn something of VBA code in excel for purpose of my job, so I have a question, is it possible to shorten this recorded macro like offseting it or something?

Range("B2").Select
ActiveCell.FormulaR1C1 = _
    "=IFERROR(R[25]C[8]:R[25]C[9],R[25]C[9])"
Range("C2").Select
ActiveCell.FormulaR1C1 = _
    "=IFERROR(R[25]C[9]:R[25]C[10],R[25]C[10])"
Range("D2").Select
ActiveCell.FormulaR1C1 = _
    "=IFERROR(R[25]C[10]:R[25]C[11],R[25]C[11])"
Range("E2").Select
ActiveCell.FormulaR1C1 = _
    "=IFERROR(R[25]C[11]:R[25]C[12],R[25]C[12])"
Range("F2").Select
.
.
.
.etc

Yes, check [How to avoid using Select in Excel VBA](https://stackoverflow.com/questions/10714251/how-to-avoid-using-select-in-excel-vba) — Foxfire And Burns And Burns, Nov 21 '19 at 10:09

score 1 · Accepted Answer · answered Nov 21 '19 at 10:19

@FoxfireAndBurnsAndBurns mentioned on how to avoid select. Besides that you need to know few tips and tricks when you are coding. You will discover them in due time provided you continuously work with VBA code.

TIP: Look for patterns in your code. If required, use a loop to perform repeated task. In your code, there is a pattern. However no loop is rquired. You can enter the formula in the entire range in ONE GO

Your code can be written in one line! Let's say you want to enter the formula from Col B to Col F.

Range("B2:F2").Formula = "=IFERROR(J27:K27,K27)"

Is it possible to shorten recorded macro?

1 Answers1