Hi all,

if cell a1 and b1 are merged and c1 and d1 are merged. if target = c1, then
target.offset(0,-1) refer to b1 not a1 and b1 merged area. How can I do it?

Clara
--
thank you so much for your help