Hi there. I'm in the process of re-organizing a maco-enabled worksheet that was passed over to me.
There are over 100 separate modules under vba, some of which contain multiple functions and subroutines, and some that are totally empty.
Is there a way to merge all of the modules into a single module that would contain all of the VBA code, or am I stuck slogging through all of them?
There are over 100 separate modules under vba, some of which contain multiple functions and subroutines, and some that are totally empty.
Is there a way to merge all of the modules into a single module that would contain all of the VBA code, or am I stuck slogging through all of them?