Hello
I am new to excel vba. I want to hide all the rows in the range (B9:Q1574) using excel vba code based on values in column Q.
I placed a button on sheet1(Home) to filter Data range in Sheet2(CB). I wrote the below code in click event of the Button.
Sheets("CB").Select
Worksheets("CB").Range("B9:Q1574").AutoFilter Field:=16, Criteria1:=">100"
But it doesn't work.
Can anyone help?
I am new to excel vba. I want to hide all the rows in the range (B9:Q1574) using excel vba code based on values in column Q.
I placed a button on sheet1(Home) to filter Data range in Sheet2(CB). I wrote the below code in click event of the Button.
Sheets("CB").Select
Worksheets("CB").Range("B9:Q1574").AutoFilter Field:=16, Criteria1:=">100"
But it doesn't work.
Can anyone help?