'Syntax error on VBA: Trying to filter based on a cell value

i am trying to filter some extensive data based on a cell value using VBA, however I keep getting a syntax error all the time I put my code, I am missing something?

Public Sub FilterDepartment_Sales()

 Sheets("BR-L1").Range"(A8").AutoFilter Field =1, Criteria1:=Cells(1, 1).Value

   End Sub

excel vba

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'Syntax error on VBA: Trying to filter based on a cell value

Sources

Related Questions