AutoFilter Working But Causing Data Glitch On Another Sheet
Hello,
I have the following code to insert a line, populate the cells and then filter the cells in a-z order. This works but every time I run it the whole range of data gets put onto another sheet but when I exit the workbook and come back in its normal. I can only think it a glitch as my code is messy. Any idea?
Code:
' INSERT NEW CARRIER AND RATES FOR FUEL AND LOLO
With ActiveWorkbook.Worksheets("Rates Matrix")
.Range("I5:M5").Insert (xlDown)
.Range("I5").Value = AddSupplier.TextName.Value
.Range("J5").Value = AddSupplier.TextFuel.Value
.Range("K5").Value = AddSupplier.Text20ft.Value
.Range("L5").Value = AddSupplier.Text40ft.Value
.Range("M5").Value = AddSupplier.Text40hc.Value
End With
'FILTER THE TABLE A - Z TO PUT NEW SUPPLIER IN ORDER
With ActiveWorkbook.Worksheets("Rates Matrix").Range("I2").AutoFilter
ActiveWorkbook.Worksheets("Rates Matrix").AutoFilter.Sort.SortFields.Clear
ActiveWorkbook.Worksheets("Rates Matrix").AutoFilter.Sort.SortFields.Add Key _
:=Range("I2:I28"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption _
:=xlSortNormal
With ActiveWorkbook.Worksheets("Rates Matrix").AutoFilter.Sort
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
End With
With ActiveWorkbook.Worksheets("Rates Matrix").Range("I2").AutoFilter
End With
AddSupplier.Hide
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
https://www.reddit.com/r/windowsxp/comments/pexq9q/comment/k81ybvj/?utm_source=reddit&utm_medium=web2x&context=3
https://www.youtube.com/watch?v=bs-urI_o8jo&lc=UgxYgiEZuS9I3xkjJv54AaABAg
https://www.youtube.com/watch?v=bs-urI_o8jo&lc=UgyBACXgNY4j_cHgH5J4AaABAg.9oTkVdzfqfm 9wlhQrYJP3M
ttps://www.youtube.com/watch?v=LP9fz2DCMBE
https://www.youtube.com/watch?v=LP9fz2DCMBE&lc=UgzbPgJUMCztIOQDym14AaABAg
https://www.youtube.com/watch?v=LP9fz2DCMBE&lc=UgzbPgJUMCztIOQDym14AaABAg. 9wdo_rWgxSH9wdpcYqrvp8
ttps://www.youtube.com/watch?v=bFxnXH4-L1A
https://www.youtube.com/watch?v=bFxnXH4-L1A&lc=UgxuODisjo6cvom7O-B4AaABAg.9w_AeS3JiK09wdi2XviwLG
https://www.youtube.com/watch?v=bFxnXH4-L1A&lc=UgxBU39bTptFznDC1PJ4AaABAg
ttps://www.youtube.com/watch?v=GqzeFYWjTxI
https://www.youtube.com/watch?v=GqzeFYWjTxI&lc=UgwJnJDJ5JT8hFvibt14AaABAg
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
