macro to Copy paste range skip zero values

Hi Ralem,

Let's say you have this in the range starting with AL5

      AL
  5   1 
  6   2 
  7   0 
  8   0 
  9   5

In A12 you want

       A
  12   1
  13   2
  14   5