This actually belongs in a General module--not behind a worksheet.

You may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

"ielmrani via OfficeKB.com" wrote:

Dave,
This is amazing. It works. What I did is go to sheet I right click it and
added the code. I open the code and click F5 to run it. can it be make as
macro I am not sure how to do that.
Thanks

ielmrani wrote:
Dave,
I used codes in Access but never in excel. How do I make this work?
Please provide me with step by step. thank you.
By the way you're right 789 was not supposed by there, it was a typo.

I'm not sure how that 789 policy showed up in in LisaC's and Mac's data--I'm
guessing it was a typo in the post.
[quoted text clipped - 56 lines]
--
Message posted via http://www.officekb.com

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200806/1

--

Dave Peterson