Howdy
When I do a count of a dyanmic named range I get 1, when I do it for a
static named range I get the correct count of the range.
This is my code:

Private Sub UserForm_Initialize()
Dim DirectorateCount As Long
Dim rgDirectorateListSource As Range

Set rgDirectorateListSource =
Worksheets("Data-Directorates").Range("DirectorateRange")
DirectorateCount = rgDirectorateListSource.count
End Sub

Do I need to use a ByVal Target as RANGE somewhere or what am I doing wrong?
Thanks
Matt