copy formulas with a line inbetween

hi, I have the pattern of data below where there's a blank cell in the first position of the second row. Is there a way to copy the formulas in the first line all the way down in one step with code? If I use the downward end of data keystroke in code it will stop at the blank line and then I have to use another line of code to copy from the second line to the end of the data.

1 2 3 4
a b c d
5 6 7 8
j k l m
9 10 11 12

Sorry, the data should look like this. There is no data in the first position of the second row.


1 2 3 4
b c d
5 6 7 8
j k l m
9 10 11 12

what would it be in code?

Maybe:

Please Login or Register  to view this content.

thx john and mike. Can we make the techniques more generic so it can work on whatever cell it's on and copy down to however long the data rows are?

the last line is trying to copy the entire row and not just the where the data is. I think it may just be easier to just do it in two simple steps for now. thx for your help.

Try:

Please Login or Register  to view this content.

it's getting better but still not right. this one is going to the row above the cursor and copying it to the original cursor row. I was trying to get the info in the cursor row and copy it to two lines below, skipping the line right after the original cursor row. it's probably not worth the extra time since I can do it fairly easily in two separate steps.