Thanks VJ, will try and let you know.
To answer your question, I am trying to dynamically concatenate the columns in the last column, i..e in Column H, I want to put Concat (A:G) where G & H columns are not static, but dynamic, based on the number of columns that sheet has.