Forum Discussion

Copper Contributor

Oct 12, 2021

Help with Macro : Macro is too long

Hi! I usually don't write macros, I just record the steps I need done and work with that, but this time I receive an error that the macro is too long. A little bit of context: I download every ...

excel

Macros and VBA

HansVogelaar

MVP

Oct 12, 2021

Alienvolm

Your macro contains an immense number of repetitions. The section

    With Selection
        .HorizontalAlignment = xlGeneral
        .WrapText = False
        .Orientation = 0
        .AddIndent = False
        .IndentLevel = 0
        .ShrinkToFit = False
    End With

occurs over and over again. It even causes this discussion to freeze.

Remove those duplicates.