trying to get a row to break....
 

I am trying to get a row of information to break down into 3 rows.

The Row incorporates cells A3:O3
I would like the macro to take A3:F3 then break, the next line placing G3:N3
then break, and finally on the 3rd line placing O3 and also increasing the
font size of cell O3 to 30.

Is this possible?

trying to get a row to break....
 

"Murph" wrote in message
...
I am trying to get a row of information to break down into 3 rows.

The Row incorporates cells A3:O3
I would like the macro to take A3:F3 then break, the next line placing
G3:N3
then break, and finally on the 3rd line placing O3 and also increasing the
font size of cell O3 to 30.

Is this possible?

It's not clear what you want.
A3:F3 to remain where it is.
G3:N3 to be cut and pasted (or copied?) to Row 4 starting at which cell (A4
or G4 or ???)?
O3 to be cut and pasted (or copied?) to Row 5, but again, to which cell?
O3 to be font size 30. Do you mean O3 or where O3's data ends up on Row 5?

Yes, it will be possible when the full data has been supplied.

Another way is to put some data into A3:O3 and record a macro as you move
your data around.

Henry