Hi Koala,

It's not as simple as it seems.

Unfortunately to actually teach you what you need to know to do this
would basically mean writing the stuff ourselves. I hate having to say
this, but I work as a contract programmer and I'm answering these
questions from work, and I really don't have the time to spend on that
as my client would not get his work done!!

What I would suggest though is that if this is becoming part of your
job, get your company to either send you on a VBA course or, get them
to buy a book such as Wrox's Excell 2000 VBA (Or whatever version of
Excel you are using) ISBN 1-861002-54-8. Use the Online help as well
in VBA.

I'm really sorry I can't help you in full.

Regards

Rich


--
Rich_z
------------------------------------------------------------------------
Rich_z's Profile: http://www.excelforum.com/member.php...o&userid=24737
View this thread: http://www.excelforum.com/showthread...hreadid=386389