Subscript out of Range when using Sheet CODENAME 1

[Ebes1099]

I'm not understanding why this line of code gives me a Subscript out of Range error. I'm using the sheet CODENAME because the tab name in Excel gets changed occasionally. If I use the actual tab name in excel it doesn't give me any errors. "MA_BPT_Rng" is a named range in my workbook.

I've tried both of these lines and I get a subscript out of range error.

numPlans = WorksheetFunction.CountA(Sheets("WCG_Inputs").Range("MA_BPT_Rng"))
numPlans = WorksheetFunction.CountA(ThisWorkbook.Sheets("WCG_Inputs").Range("MA_BPT_Rng"))

 

[SkipVought]

Hi,

I don't understand your reference to the sheet code name with respect to your code examples.

Assuming that the CodeNames is WCG_Inputs...

NumPlans = WorksheetFunction.CountA(WCG_Inputs.Range("MA_BPT_Rng"))