Hello guys, was wondering if anyone would be able to help me out with the following code.
Using some help from online guides, I have managed to create an autofilter to filter out keywords from a VERY long column with a lot of information. I have it set to when I hit a command button the filter begins and sorts out. it does work however when I get to the end of the coding window it seems to just break? and I'm not entirely sure on the why?
would anyone be able to offer any assistance?
here is roughly the code I'm using.
Private Sub CommandButton1_Click()
Sheet2.Range("A1:P1").AutoFilter Field:=7, _
Criteria1:=Array("Apples", "Oranges", "Carrots", "Peas", "and like I said this works but it continues to go this way >>>>>>> very long and it breaks."), _