Quote Originally Posted by Marc_excel_tips View Post
Hi Wegwerf,

thanks for your reply, especially for pointing out the other script.
HTML Code: 
Somehow I couldn't get the scripts working in my own file, so I decided to just download the "Japanese" file that was in Fred Lo's post.
The script in that file works great > thanks for that Fred, I have added your reputation

I tweaked the script a bit, as I didn't find it handy to change the language in the script itself.
Specially if the macro needs to be used by people that don't understand much of excel.
So I turned the "Japanese" file into a more "tool"-like sheet, that is easy to use for everyone if you just follow the directions on the start sheet.

The only thing I am still struggling with, is that the macro works great but is a bit slow sometimes.
Especially when you put more then 1000 cells in it for translation it takes a while before it's done running.
Also, the macro sometimes get stuck if the input is not correct (i.e. input = start...), the macro seems to get stuck on those "...".
It would be great if I had something like an "on-error-skip" script that could be added to the script.

But for now it's working pretty fine.
Attached the "tool"-like version of my file (maybe you find it easy to use as well Wegwerf.

Again, thanks for pointing me on the other script.
Hi,
Thank you for providing the template. When I am trying to translate multiple rows that template only translate for the first row and populate same in rest of the rows. can someone please provide input how to fix this issue?