Hello,

Having some intermittant problems with a macro I'm using to create individual sheets from a list - it autofilters to display each row, and copies the contents to a new sheet named after the "Name" column of the row.

Here is the portion of code that creates the sheets: 
Please Login or Register  to view this content.
The names start at A8 and the filter usually works to display a single name in a8, copy all the contents, create the page, move on to the next name, only display that one etc etc.

This works 90% of the time. However, some names just don't seem to work with this method and I have been racking my mind to figure out a pattern but I can't. For example - if the list includes "Terry Woo" then all of the entries on the list have terry woo in a8 and then the subsequent name in a9. If I change it to "Terry Wooo" then it works find and only a single row shows up when filtered. Even when I manually filter the row and select only 1 entry to be displayed it displays that entry & Terry Woo.

Any thoughts on this - I've tried about everything I can to figure it out to no avail.

Thanks