Can have look at my post "Extracting data from column C to Column K".. I need ur help.. By the way your code in the previous code works.. thank you very much..