Range("A1:HH2").Merge
Range("A3:HH4").Merge

"Herman" wrote in message
...
I have a very large range of cells I would like to merge
"A1:HH1" with the cells directly below them "A2:HH2" and
then repeat the same for "A3:HH3" with "A4:HH4" and so on.
I recorded a macro doing the following steps "record macro"
selected cell A1 shift down arrow to select cell A2 the hit
merge and center button stop record. what do i need to add
to make this do the required ranges.
thanks Herman.