title: copy cells in a range to a column
body: <p>i have MyRange = A1:C3</p>
  
  <p>current values in the range are as below:</p>
  
  <p>A1=a, B1=d, C1=f
  A2=b, B2=e, C2=""
  A3=c, B3="", C3=""</p>
  
  <p>the blank cells in the range can vary.</p>
  
  <p>how can i copy (using vba) non-blank values from MyRange and paste them all together let's say to column AA? </p>
  
  <p>Eg:
  AA1=a
  AA2=b
  AA3=c
  AA4=d
  AA5=e
  AA6=f</p>
  
  <p>Thanks again guys :-)
  Paul</p>