Need help with SendKeys function

[rlill]

Hello

I have developed an VBA application that is able to get coordinates from Google API if user inserts address into the right cell. After finding coordinates it can find nearest another coordinates from another database. That all works well. Now if I tried my application in another computer in another network there occured a problem. After inserting like 50 addresses I only get back half of the coordinates in irregular order. Only way I can get all the coordinates is to press "ENTER" in every address cell manually, so it requests the data from Google one by one. And so it works in my another computer. But if there is 50 or 150 and so on addresses it is not very efficient way to work with so. And now comes my question. Is it possible to write a macro that is able to check the value of the cell and if it says "#VALUE!" then hit "ENTER" and move on to next cell.

Look the picture. Some of the cells contains "#VALUE!". If I hit enter that cell then it gets the coordinate.
I would appreciate it a lot if somebody could help me find a solution to my problem.

 

[rlill]

Or there is some better way how to solve this problem? [h=2]SendKeys function was just the first idea that popped.[/h]