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?
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHACode:' 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.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
Bookmarks