Copy entire row

[Johnboy]

Hi All,

I trying to create a macro to copy entire row at cursor loaction. If cursor is in cell B12 then copy row 12 to another sheet.

Thanks
Johnboy

 

[nbrcrunch]

you'd spend more time creating and using such a routine than just copying it.

step 1: Shift and Spacebar
Step 2: Ctrl-C

Even faster, right-click on row number, choose copy.

 

[Johnboy]

nbrcrunch,

Ture, but this command is within another macro.

 

[lenze]

Maybe

Selection.EntireRow.Copy

lenze

 

[Johnboy]

Thanks Lenze

Worked

Johnboy

 

[nbrcrunch]

Johnboy,

I've posted things in the past that others have kindly reminded me I could have figured out much quicker if i had just turned on the macro recorder and done the step and then examine the code. This is one of those times.