Macro for countif with dynamic range { R [i] C [j] : R[i] C [j+10] }

Dear Team,

Need to write a macro to count (countif) a particular variable in a row. The Range is dynamic { R [i] C [j] : R[i] C [j+10] }
The result should be stored into a variable. Please provide with a sample code for the same

In the below example, Range("B2:L2") should be replaced with R [i] C [j] : R[i] C [j+10] to make it dynamic
X = Application.WorksheetFunction.CountIf(Sheets("Data").Range("B2:L2"), "Open")

Regards,
Lijo

Getting a run time error '1004'. Removed zero in Resize and it worked. Thanks a lot