![]() ![]() If you apply Specialcells to only one cell, it actually applies to the entire used range of the sheet. Worksheets("For Slides").Range("P29").PasteSpecial Range(r(1), rC).SpecialCells(xlCellTypeVisible).Copy Set r = Range("B2", Range("B" & Rows.Count).End(xlUp)).SpecialCells(xlCellTypeVisible) Worksheets("OLD_Master").Range("A:H").AutoFilter Field:=5, Criteria1:="Drinks" Worksheets("OLD_Master").Range("A:H").AutoFilter Field:=4, Criteria1:=Array( _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ Selection.sort Key1:=Range("H1"), Order1:=xlDescending, Header:=xlGuess, _ Worksheets("OLD_Master").Columns("A:H").Select Any ideas on why this code won't work when there is only one item? Sub top10() ![]() When I manually add one more item to this filter (total 2), then it copies it fine. ![]() I found that when there is only one item in column B after filtering, it doesn't copy that one cell - instead it copies the entire row and seems to be a strange selection. I have been using this for many different filtered selection, but I came across a problem with one of my filter combinations. The following code applies filters and selects the top 10 items in column B after some filters are applied to the table. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |