How to sort a chart from first to last row/column

Question

0.00/5 (No votes)

See more:

Excel-2016

I would like to sort my chart from a-z I am having an issue finding a way for this to affect all the columns in the chart.

What I have tried:

LastRow = Cells(Rows.Count, 17).End(xlUp).Row
LastCol = Cells(7, Columns.Count).End(xlToLeft).Column

    ActiveWorkbook.Worksheets("Data").Sort.SortFields.Clear
    ActiveWorkbook.Worksheets("Data").Sort.SortFields.Add2 Key:=Range("Q7", LastRow), _
        SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
    With ActiveWorkbook.Worksheets("Data").Sort
        .SetRange Range("Q7", LastCol)
        .Header = xlNo
        .MatchCase = False
        .Orientation = xlTopToBottom
        .SortMethod = xlPinYin
        .Apply
    End With

This is code from a recorded macro that I tried to edit but I am getting an error saying range of object global failed.

Posted 24-Feb-22 5:37am

Human Person

Updated 24-Feb-22 5:51am

v2

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Human Person · Accepted Answer · 2022-02-24T05:51:00

ActiveWorkbook.Worksheets("Data").Sort.SortFields.Clear
   ActiveWorkbook.Worksheets("Data").Sort.SortFields.Add2 Key:=Range("Q7", Cells(LastRow, "Q")), _
       SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
   With ActiveWorkbook.Worksheets("Data").Sort
       .SetRange Range("Q7", Cells(LastRow, LastCol))
       .Header = xlNo
       .MatchCase = False
       .Orientation = xlTopToBottom
       .SortMethod = xlPinYin
       .Apply
   End With

How to sort a chart from first to last row/column

1 solution

Solution 1

Add your solution here

Preview 0

How to sort a chart from first to last row/column

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us