Excel VBA: Copy entire row 1571 and pastespecial to current row

[Softedge88]

How do I copy the contents of the entire row 1571 in an excel spreadsheet and pastespecial / formulas to the current row? I would like to assign this macro to a button ( I know how to do this).

I have tried using the macro recorder but seems to only allow me to paste to the row selected at the time of recording. I would like to place the cursor on a row and then have the macro copy the contents of the entire 1571 row and paste them to the selected row.

Regards,
Arthur

 

[SkipVought]

Hi,

Please post VBA questions in Forum707.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[cckens]

Arthur,
What Skip is trying to say is that this is most likely to be solved in the referenced forum as this would require more coding than macro recording can do...

Sorry, Skip, sometimes it's a little too blunt to keep whacking them with the:

GOTO VBA_Forum

VBA_Forum:
End Sub

Ken

"cckens is a nick... why the H-E- double-hockey-sticks am I using a nick for a name? Am I afraid of who I am?"
-me
"...don't know why, but I think of chickens when I see that nick...maybe even choking chickens???"
-Tony (wahnula)

 

[SkipVought]

Ken, you'll notice that the OP already posted in the referenced forum and received an answer.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[cckens]

I know, just jibing you... if it is spammy I apologize...

Ken

"cckens is a nick... why the H-E- double-hockey-sticks am I using a nick for a name? Am I afraid of who I am?"
-me
"...don't know why, but I think of chickens when I see that nick...maybe even choking chickens???"
-Tony (wahnula)