Hi
Thank you for the solution. But I have one more problem
my range in sheet one is "D4,D6,D8,D10,D12,E4,E6,E8,E10,E12" to be precise. So by your code I can use "offset(2,0)" till D 12, but the next selection E2 will be a problem. Could you please help....