I need help with the following problem. I inherited a macro that my employer wants me to insert code that will filter out rows based on a double between +- 20 that is passed from a form. I need to filter out rows where AlternateNum = the number passed from the form.

Here is a snippet of the place where the code needs modification.
'Rectangular Duct
ExRS.setFilter "[Service Type] = 'Rectangular Duct'"
( )
ExRS.quickFill Range("Ductwork_Fabricated_Total").Offset(1, 1), "0-7,2"

Here is one way that I was thinking about solving the problem but it doesn’t work.

'Rectangular Duct
ExRS.setFilter "[Service Type] = 'Rectangular Duct'"
ExRS.setFilter "[Alternate] = AlternateNum"
ExRS.quickFill Range("Ductwork_Fabricated_Total").Offset(1, 1), "0-7,2"

Thank you
Paul