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

[Jim A]

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 range
("A27:L27") . 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.

Thanks for any help - JimA

 

[CurlyDave]

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 range
("A27:L27") .  I would also like the macro to insert a new blank row (or
insert the copied row) for the purpose of shifting existing SUM functionson
sheet 2 down.  I would like those functions to be right below the
copied/pasted cells every time the macro is executed.

Thanks for any help - JimA

How many times are you going to ask this question?