Macro to copy filtered rows into new individual worksheets. Runtime Error 1004- line 25

Hi J_Lee_M,

Welcome to the forum!!

Two reasons I can think of are that firstly (and most probably) there's no value being assigned to the UListValue variable. Test this by putting the variable in a message box i.e. MsgBox UListValue just before trying to rename the tab. The second is that there is one or more illegal characters in the UListValue variable that is causing the error, but I'd say this is less likely as the error message in that case specifically states that this is the problem.

BTW - a tab can have a maximum of 31 characters so I'm guessing your code should be Left(UListValue, 31)?

HTH

Robert

Thank you Robert! I apologize for being dense - but could you clarify "Test this by putting the variable in a message box i.e. MsgBox UListValue just before trying to rename the tab"? Maybe this is where I'm messing up - but I was under the impression that the Macro (not me) would be renaming each new sheet to the unique variable stored in the UList.

Thanks for your time - I certainly appreciate it.

I was under the impression that the Macro (not me) would be renaming each new sheet to the unique variable stored in the UList

Correct. The issue I'm guessing is that there's a blank cell in Col. A that is being added to the UList collection which the macro then tries to rename a tab as such which is why it's failing.

See if incorporating these lines of code where you create the array (collection) does the trick:

Please Login or Register  to view this content.

Though I don't know all of your code, there may be conflicts the next time you run the macro as each tab in a workbook must be unique.

HTH

Robert

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.