Hello everyone, hello KjBox
KjBox can you please help me with an error in the vba code that you so very kindly provided me with? It is the vba code that splits rows into the machines, based on the column that contains that number of the machine: it splits the rows from the sheet SPARTISCI containing that machine number in column B ,into the machine sheets; and they are non contiguous columns so you wrote a wonderful code taht worked perfectly untill yesterday.
I do not know why.
What I tried to do : two weeks ago, I added in the vba code another column form X sheet (the source sheet) to go into the machine sheets and it still worked like a charm.
Today, when I had to update the machines after a few days that we weren't working in the company, it gives me an error and highlights this line:
.Cells(8, 1).Resize(lRow - 7, 13).Borders.Weight = 2
Now, why did it start giving error if it worked fine untill yesterday?
The only thing I added is two new sheets in the same workbook wich however have nothing to do with the machines.
Funny thing is for some machines it works fine even if it gives me the error: the code puts the rows in some of the machines, gives the error and does not compile other machines.
Please help me...I have to plann 106 orders ahead tomorrow....I am at lost without your help. I am desperate...this code helped me do my job in the last month in a way I couldn't hoped for otherwise.
Thank you so so much, I attach the file as it is. Thank you relly in advance