Using a formula (=OFFSET) in a named array?

Hey,

So I have a loop that finds a worksheet, cat, and then names an array, cat, that is supposed to have the following value.

:=OFFSET(cat!A2,0,0,COUNTA(cat!$A$2:$A$100),1)

I know that code works when you input it directly into the name manager, but I'm having trouble creating the loop that will create the array with cat being a variable. This is what I have tried:

ThisWorkbook.Names.Add name:cat,RefersTo:=OFFSET(cat!A2,0,0,COUNTA(cat!$A$2:$A$100),1)

Suggestions?