Repeating a Macro on Different Cells

[belal86]

I'm a newbie and have never used macros before. I would like to have the following code repeat until row 245 if anyone can help. Thanks in advance

<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Menlo}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Menlo; color: #011993}span.s1 {color: #011993}span.s2 {color: #000000}</style>Range("N2:CK3").Select
    ActiveWorkbook.Worksheets("Sheet1").Sort.SortFields.Clear
    ActiveWorkbook.Worksheets("Sheet1").Sort.SortFields.Add Key:=Range("N3:CK3") _
        , SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
    With ActiveWorkbook.Worksheets("Sheet1").Sort
        .SetRange Range("N2:CK3")
        .Header = xlNo
        .MatchCase = False
        .Orientation = xlLeftToRight
        .SortMethod = xlPinYin
        .Apply
    End With
End Sub

 

[frank_AL]

Re: Need Help with Repeating a Macro on Different Cells

Can you try again to explain what the outcome is that you are wanting to achieve? Right now your code is only sorting 2 rows. Trying to understand the purpose of repeating this code down to row 245 which at face value would simply sort 2 rows at a time until you reach row 245 which doesn't seem logical.