Error in Visual basic (9)

[saveriogazzelloni]

Hi, when I try to link the project I receive a message error from Visual basic. This is the line-code where the problem is set be debugger

    Set letzteZelle = .UsedRange.SpecialCells(xlCellTypeLastCell)
    SortFromRow = 7
    SortByColumn = 2
    
    .Sort.SortFields.Clear         <----  here there is the stop, the alert says : "index not included in the interval"

can you help me ?

thanks in advance Saverio

[bpetraus]

Hi @saveriogazzelloni ,

can you please describe this a little bit more in detail?

Best

Bernd