Sort macro

[Shadkng]

Hi, I recorded the macro to sort a range starting at A3 to column D, down to last row. I want to sort ascending in column C and then D. I changed the key:=Range("C3:C100" _ in line 6 & 8 to key:=Range("C3" _, and it seemed to work. However, I dont know what to do with the this on line 11: .SetRange Range("A3:D100") to not limit at 100. Thanks

Sub SORT_TOT_FAB()
Application.ScreenUpdating = False
Range("A3:D3").Select
    Range(Selection, Selection.End(xlDown)).Select
    ActiveWorkbook.Worksheets("TOT FAB").Sort.SortFields.Clear
    ActiveWorkbook.Worksheets("TOT FAB").Sort.SortFields.Add2 key:=Range("C3:C100" _
        ), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
    ActiveWorkbook.Worksheets("TOT FAB").Sort.SortFields.Add2 key:=Range("D3:D100" _
        ), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
    With ActiveWorkbook.Worksheets("TOT FAB").Sort
        .SetRange Range("A3:D100")
        .Header = xlGuess
        .MatchCase = False
        .Orientation = xlTopToBottom
        .SortMethod = xlPinYin
        .Apply
    End With
    Range("E3").Select
    Application.ScreenUpdating = True
End Sub

 

[Shadkng]

Glad it's sorted & thanks for the feedback.

I meant when I manually format it to number it works as a test. But I don't want to have to do that. I was hoping the macro can change the format to number.

 

[Fluff]

Simply changing the format of a cell should not make any difference, as it does not change the underlying value.

 

[Shadkng]

Simply changing the format of a cell should not make any difference, as it does not change the underlying value.

OK,so maybe I'm asking the wrong questions. Is there a way to have sample A result in sample B?

sample A
19
21
23
66
8

Sample B
8
19
21
23
66

 

[Shadkng]

Simply changing the format of a cell should not make any difference, as it does not change the underlying value.

I just realized what you mean it has nothing to do with the format. But when I sort the data using "data / sort" from the ribbon, it sorts the way I want. But the way it sorts in macro is different?

 

[Fluff]

The best way is to convert your numbers into real numbers, it can save you a lot of problems.

 

[Shadkng]

Simply changing the format of a cell should not make any difference, as it does not change the underlying value.

Fluff, disregard all my recent posts...I had my sort macro disabled so it wasn't really sorting. Sorry to waste your time. It's working correctly. Thanks