I would like to have a macro that will assign a Range Name based on all the columns with data in them. This will vary from one worksheet to another for the end user. So I have a macro doing this based on an existing assigned Range in the worksheet but would like to change that to be variable.
This is most of the code I am using now that is splitting the worksheet data into separate worksheets based on the unique values in column A. And I would like to leave ws1 and rng open based on the active worksheet the end user has open. 

Please Login or Register  to view this content.