I am using VBA to create new worksheets. The worksheet names are basedon VBA Module Name (where the Sub codes are running).My question is how to get the Active Module Name with VB Code.
Is the code you are running in more than one module?