Hello all,

I have a trouble with sorting data on hidden columns in the same sheet. I can not sort the data since it is hidden.

I thought that it is caused by Goto method but I also tried this without selecting and it does not fixed. Is there any way to sorting the hidden column on the same sheet? Here is my code below:


Application.Goto Reference:="SiralaGRF1", scroll:=False
ActiveWorkbook.Worksheets("Gösterge Paneli").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("Gösterge Paneli").Sort.SortFields.Add Key:=Range( _
"W8:AL8"), SortOn:=xlSortOnValues, Order:=xlDescending, DataOption:= _
xlSortNormal
With ActiveWorkbook.Worksheets("Gösterge Paneli").Sort
.SetRange Range("W6:AL8")
.Header = xlYes
.MatchCase = False
.Orientation = xlLeftToRight
.SortMethod = xlPinYin
.Apply
End With


Thanks for your help!