Originally Posted by
ahlecks
hello guys,
i have this macro generated command which is very long and when run will pop-up an error which is it is too long to compile. if i'm right, this can be done through looping command. can anyone help how to make this into a looping command?
thank you!
[b] Sheets("1").Select [b]
[b] Range("A11:C191").Select [b]
[b] With Selection[b]
[b] .HorizontalAlignment = xlGeneral[b]
[b] .VerticalAlignment = xlCenter[b]
[b] .WrapText = False[b]
[b] .Orientation = 0[b]
[b] .AddIndent = False[b]
[b] .IndentLevel = 0[b]
[b] .ShrinkToFit = False[b]
[b] .ReadingOrder = xlContext[b]
[b] .MergeCells = True[b]
[b] End With[b]
[b] With Selection[b]
[b] .HorizontalAlignment = xlGeneral[b]
[b] .VerticalAlignment = xlCenter[b]
[b] .WrapText = False[b]
[b] .Orientation = 0[b]
[b] .AddIndent = False[b]
[b] .IndentLevel = 0[b]
[b] .ShrinkToFit = False[b]
[b] .ReadingOrder = xlContext[b]
[b] .MergeCells = True[b]
[b] End With[b]
[b] With Selection[b]
[b] .HorizontalAlignment = xlGeneral[b]
[b] .VerticalAlignment = xlCenter[b]
[b] .WrapText = False[b]
[b] .Orientation = 0[b]
[b] .AddIndent = False[b]
[b] .IndentLevel = 0[b]
[b] .ShrinkToFit = False[b]
[b] .ReadingOrder = xlContext[b]
[b] .MergeCells = True[b]
[b] End With[b]
[b] With Selection[b]
[b] .HorizontalAlignment = xlGeneral[b]
[b] .VerticalAlignment = xlCenter[b]
[b] .WrapText = False[b]
[b] .Orientation = 0[b]
[b] .AddIndent = False[b]
[b] .IndentLevel = 0[b]
[b] .ShrinkToFit = False[b]
[b] .ReadingOrder = xlContext[b]
[b] .MergeCells = True
Bookmarks