Quote:
Originally Posted by excelledsoftware
I did the research and know how to get this to work on every workbook in a folder.
|
That's great news!
Quote:
Originally Posted by excelledsoftware
I need to know where else to have the carriage returns removed. since this code will process 50 workbooks no problem I want to write it once and make sure it is right.
|
I went back and took a look, and that spread sheet is a good representation.
My main task is to remove the carriage returns with the columns that have the numbers, and replace the carriage returns with commas: they must have commas (e.g., 1,1, 1,3, 1,4,23). The problem was I couldn't' use your current code because it couldn't find the headers with the names written in the code because they both have carriage returns in them with the word "sheet" wrapping under it. My bad: I missed that originally. So, I don't need commas in the headers. Whether you find a solution to read the header names with their carriage returns, or write code to remove them, it's up to you; the main objective is to reformat the numbers in the columns with commas.
Once I fix that to match your code, then it works fine.