Re-record the macro but select the required range first.

Regards
BrianB
===========================================


"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.