Sub in personal needs to read another sub in current worksheet

asked 2023-01-18T18:54:45.73+00:00
luis porto 0 Reputation points

Hello VBA experts!
I have a sub in personal.xlsb that needs to read a sub in the user's workbook.

The user creates a SUB called dataClean in his worksheet. The name will always be this. This should be read by my main routine.

It only works when I put DATACLEAN in module 2 of my personal.xlsb.

Is there a way to do this?

thanks

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
1,933 questions
No comments
{count} votes