VBA Code for Arrow

Hi,
I barely dare to ask, but could anyone tell we wat de VBA code for the down arrow is?

I want to make a macro:
loop
if current cell empty?
if yes then delete and move contens to the left
down
end loop

tia