Type mismatch with CustomProperties

[gfunkdave]

I'm trying to reference a CustomProperty I defined on a worksheet in VBA but I get a Type Mismatch error every time. Can someone explain what's going on?


I'm doing this in the Immediate window while the macro is paused. ws is a worksheet object.

ws.CustomProperties.add "Roster", "no"
?ws.CustomProperties("Roster").Name  'gives Type Mismatch
?ws.CustomProperties("Roster").Value 'gives Type Mismatch

 

[gfunkdave]

It looks like I can't edit the post above but it's worth noting that referring to the property by index number works.

ws.CustomProperties.add "Roster", "no"
?ws.CustomProperties(1).Name  'returns "Roster"
?ws.CustomProperties(1).Value 'returns "no"