The translation feature on excel 2016 only works on one cell at a time and the user needs to manually copy and paste the translation.
I tried recording a macro but the macro does not detect the translation function.
i would appreciate if anyone can get a macro to detect this function.

thanks in advance!