Using Ron de Bruin RangetoHTML on multiple macros

[bdouglas1011]

I have multiple macros that are in their own modules and I have the "RangetoHTML" at the bottom of all of them so they run perfectly.

My questions is I am trying to clean up the code and wondered can you have that code by Ron de Bruin RangetoHTM in a separate location and if any macro that is generating an email can go and utilize the code from there and not need to add to every macro separately.

Thanks

[CK76]

You can store the subroutine in separate module and run it in other subroutines.

Ex: Store RangetoHTML in Module2. And others in Module1.

[bdouglas1011]

When i do that i get Compile error
expected variable or procedure not module

[CK76]

Can you upload sample workbook with desensitized data?

[bdouglas1011]

unfortunately this workbook is huge with a ton of code ill try to extrapolate this one out and send it.

but my code worked fine with

Please Login or Register  to view this content.

that was all in one module
now i split it up and put the html code by itself in a separate module that code was.

Please Login or Register  to view this content.

and the range to html is

Please Login or Register  to view this content.