title: Using macro Concatenation of Multiple Columns
body: <p>please anybody help in concatenating cells using Excel 2007 macro. I have columns A to E. I want to concatenate all the Columns in column F. Please note that I don't know the exact number of rows in the all the Columns, but macro should stop concatenating when there are no values in the said columns. Sample:</p>
  
  <pre>
  A       B           C          D     E           F
  O      ABC         DEF        GHI    E       OABCDEFGHIE
  
  O      JKL         MNO        PQR    E       OJKLMNOPQRE
  
  O      STU                   VWXYZ   E       OVWXYZE
  
  
  </pre>