Thanks Bob - the problem was that the Dim statements for arrays were in
a Private Sub. Once I moved them to the declarations section the
module the code worked fine.

Cheers,
Stuart