Hello, I have code that filters a file for all unique records in col A and saves a file for each set of unique records. so if there are 5 unique records, there would be 5 files created. the problem I am having is trying to save the files to sharepoint. I am able to save to sharepoint when there are no symbols or alpha numeric characters in the folder. I used an Alphanumeric function to try to remove the special characters from the name before saving to the folder, but I am getting a 'index refers beyond the list' error and I am not sure how to resolve it yet. Please provide some assistance. Below is the code and Ive bolded the error and line causing error. I also included the Alphanumeric function I have used :

Please Login or Register  to view this content.
Alphanumeric function code
Please Login or Register  to view this content.