Hi there i just found this Thread which could serve my issue. Well i need something similar to all this but i need to translate words in a specific column. I have words in english in Column A and i need to translate them in Column B. But lets say i dont want this as a fixed set up. I would like to select whichover column is needed and translate the words in the next on the right. Could you help with something like this?
Great thread.
I have tried to do this, managed to get it to work the once but for some reason now it stopped working...
on translation I am getting the following in each cell of the new translaltion sheet.
"OCTYPE html PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN>
<html>
<head>****** http-equiv=content-type content=text/html; charset=utf-8>****** name=viewport content=initial-scale=1><title>http://www.google.com/</title></head>
****** style=font-family: arial"
FYI - I used vba code in 5 and 7 and that's it...
strUrl = "https://translate.googleapis.com/translate_a/single?client=gtx&sl={F}&tl={T}&dt=t&q={S}"