To use the code rather than rewrite

Hi,

I have few modules of coding and use the same codes in different modules. I want to use the code in a module which is available in another module. Please see the examples below.

First Module
--------------

Please Login or Register  to view this content.

Second Module
----------------

Please Login or Register  to view this content.

Instead of writing same for loop codes in different modules, how can I use this code by function or any other feautures?

Please help.

I'm not sure where Goto 183 leads to. If it is just a way to get out of the loop (rather than Exit For), each of those sections could be replaced with a Select Case construct.

Please Login or Register  to view this content.

@Mike: I think the OP needs to know how to make it a subroutine or function that can be passed a parameter ... and, therefore, be reusable.

Regards, TMS

A function was where I was heading, in this case

Please Login or Register  to view this content.