Folks...

You gotta help me. I want to paste a serious of questions from column B on
sheet 1 into column B on sheet 2. However the cells on sheet 2 are merged
between B and G which means that when I paste into sheet 2 I get the contents
in every horizontal cell B C D E F & G. I have 2000 questions to copy across
30 sheets. All I want to do is copy and paste. Is there a way to make sure
when I paste that the question fills the merged cell rather thah demerging it
and laying down 6 repeats of the question that I have to back into and
demerge?

You'd think life would be simpler!

Thanks

Gordon...