Quote Originally Posted by himanshu_s View Post
2. Use of worksheets function is not allowed.
Why not? Is this a homework assignment?

Can you use worksheet functions if they're within a macro?