I think the most difficult part of any coding is building in the validation
checks. The actual work usually pretty straight forward.

I think I'd start by lurking in these here newsgroups and even buy a book.

Debra Dalgleish has a big list of books for excel at:
http://www.contextures.com/xlbooks.html

John Walkenbach's is a nice one to start with. I think that John Green
(and others) is nice, too (for a second book??). See if you can find them
in your local bookstore and you can choose what one you like best.

xcelion wrote:

Hi Dave,

Thanks a lot for rewriiting the code itself.Iam new to Vba coding
That's why code look some what less readable.Any way i admire your
coding .Checking for the object every time is the one thing i have to
look after.Please advise me on the good coding tips to prevent program
crashes .I will try your fuction and get back to you.Thanks a lot

Thanks
Xcelion :)

--
xcelion
------------------------------------------------------------------------
xcelion's Profile: http://www.excelforum.com/member.php...o&userid=16287
View this thread: http://www.excelforum.com/showthread...hreadid=313732

--

Dave Peterson