FilterSheet_1By1 + FilterSheet_Clear

Sets Autofilter in a sheet, and another function to clear Autofilter
FilterSheet_1By1 will set filter in a sheet for a certain table in a sheet.
Table means any list of cells (columns and rows) that identified by having no break
You can set the cell where that filter to be created (any cell within that Table)
This one will filter table by 1 value in 1 column
We are planning to have in future a filter by more than 1 value in more than 1 column.

CodeFunctionName
What is this?

Public

Tested

Original Work

Access is limited.

Login here using your Linkedin account. to see or download code.

No registration, not another password to remember, login using your Linkedin account and have access to all public codes in Mydev.net

Linkedin Login

FilterByValue, Optional FilterColumn = "B", Optional Wb = "This", Optional Shee = "This", Optional FilterA1 = "A1"
Or
Optional Wb = "This", Optional Shee = "This"

Views 1,368

Downloads 465

CodeID
DB ID