Photospheric Macroturbulence in late-type stars