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
Bookmarks