It depends on many things. In general, you should try to make your code modular and reusable as much as possible. You never know when or where you'll be able to use your code again. -Especially with constantly changing business requirements. If you use the same function elsewhere and just cut-and-paste, then you create the problem of having to update n number of copies of the same sub.

-P0w3rK!d