VBA syntax for NAMED RANGE in table

[ddub25]

I have this line of code below that references the specific rows within each column of a table. Ideally I want the ranges to reference the columns as named ranges. For example, I have named column B 'Category'. What is the syntax to use that named range instead of, '(Range("B27:B142")' ?

n = Application.WorksheetFunction.CountIfs(Range("B27:B142"), "Strength", Range("K27:K142"), "U-Pu-1", Range("L27:L142"), 1, Range("M27:M142"), "H")

Any help would be greatly appreciated.

 

[DanteAmor]

Try:

n = WorksheetFunction.CountIfs(Range("Category"), "Strength", Range("K27:K142"), "U-Pu-1", Range("L27:L142"), 1, Range("M27:M142"), "H")

 

[ddub25]

Thanks Dante, much appreciated - problem solved.