merge cells marco "help"

  • Thread starter Thread starter Herman
  • Start date Start date
H

Herman

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.
 
Re-record the macro but select the required range first.

Regards
BrianB
===========================================
 
Back
Top