looking for an empty row to paste a range of copied cells

Hi - I am trying to make a code that will copy a range ("A27:L27") on sheet 1 and then look for the next empty row on sheet 2 and paste it in that row. I would also like the macro to insert a new blank row (or insert the copied row) for the purpose of shifting existing SUM functions on sheet 2 down. I would like those functions to be right below the copied/pasted cells every time the macro is executed.

Hi - I am trying to make a code that will copy a range ("A27:L27") on sheet 1 and then look for the next empty row on sheet 2 and paste it in that row. I would also like the macro to insert a new blank row (or insert the copied row) for the purpose of shifting existing SUM functions on sheet 2 down. I would like those functions to be right below the copied/pasted cells every time the macro is executed.

Need to supply a little more information, and a sample workbook never hurt...
Post A27:L27 from sheet 1 to where? and when would you want to do this? Is this going to sheet 2, and if so, is that why the reference to the "next empty row on sheet 2" ?

And the last part of your statement you really confused me with... You want to insert a new blank row, to shift down the existing rows... so that those functions are right below the copied/pasted cells? Wouldn't that imply that there's no empty row inbetween them?