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