Thank you Matt for the vote of confidence!

VB6 has always been my ambition as I like the language, I will
definately move on to that as it is the next logical step for me and I
am always willing to learn.

I do think that you can learn a lot though from starting off copying
recorded macro code and then attempting to write it, i am suprised by
the amount of resources available to guide people on their way! even
the help within excel vba is good once you start to understand the code
and this group has been excellent for bouncing ideas and learning.

I might remove the data from the file as Edwin suggests above and try
to iron out any user issues, then I'm definately getting hold of vb6!

Duncan