Your formula refers to two separate sheets

Data-Directorates
DataDirectorates

--
Regards,
Tom Ogilvy


"Matt Jensen" wrote in message
...
It is defined like this
=OFFSET('Data-Directorates'!$A$1,0,0,COUNTA(DataDirectorates!$A: $A),1)
Cheers
Matt


"Nigel" wrote in message
...
I do not see anything wrong. Is your named range DirectorateRange
correctly
specified?

--
Cheers
Nigel



"Matt Jensen" wrote in message
...
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