"Weatherlawyer" wrote:
Thanks Max. I believe where I was going wrong
was with which cell I was highlighting to do the dirty.
I am once again very grateful indeed.

You're welcome !

I am definitely going to go on some sort of course with this stuff.

You're actually already onto one of the best "course" right here in these
excel newsgroups (some groups listed below). There's a lot that one can
pick up by reading/trying out the posts and the responses given.

microsoft.public.excel.newusers
microsoft.public.excel.misc
microsoft.public.excel.worksheet.functions
microsoft.public.excel
microsoft.public.excel.programming
etc

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----