VBA work around/substitute for CHOOSECOLS in Office 365

[Pookiemeister]

How can I find a work around for the CHOOSECOLS function for VBA? I have read that CHOOSECOLS function does not work yet in VBA. The following code does exactly what I need it to do on the spreadsheet.

=COUNTA(CHOOSECOLS(FILTER(A:T,(L:L=C165)*(R:R=C168),""),1))

Description of the spreadsheet:
Range(A:T) is my entire Table
Range(L:L) is my work center (Packaging, Maintenance, Processing)
Range(R:R) is the order status (Open or Closed)

Example:

=FILTER(A:T,(L:L="Packaging")*(R:R="Open"),"")

This will show ALL the "Open" order status' information for that work center. I just need the count. So that would be just one column count, not all the count for the columns displayed. CHOOSECOLS does that but not in VBA.

So basically, I just need to check each work center to figure out how open and closed orders each have? Thanks in advance.

 

[RoryA]

If you only want one column, use INDEX.

 

[Pookiemeister]

@rory Could you give an example please? Thank you.

 

[Cubist]

Filter on column A only.

=COUNTA(FILTER(A:A,(L:L=C165)*(R:R=C168),""))

 

[Pookiemeister]

@Cubist Wonderful!! So simple. I guess I was overthinking the answer. Thank you.