Quote Originally Posted by Naveed Raza View Post
You mean to say you have added new two more column right , if its so then replace below code

LC = 7
with this

LC = .Cells(1, .Columns.Count).End(xlToLeft).Column
Simply amazing!
Everything is solved!

There's just one thing Naveed, and I apologize for this, but it's important; the special characters are actually required, so leaving out ä, ö, å etc. is out of the question for my project.
Do you have any suggestions?
After this, the whole thing will be SOLVED!