Copy a fixed selection to the current cell...

[Todd K]

Maybe I am overthinking this - but I need a macro that will allow me to copy the contents of cells A1:F5 to begin at the cell that is active when the macro is executed. I have tried creating a named range, and generating a macro, but always lose the focus of the starting cell...can anyone help resolve that problem?

 

[gplhl]

On 2002-02-28 16:15, Todd K wrote:
Maybe I am overthinking this - but I need a macro that will allow me to copy the contents of cells A1:F5 to begin at the cell that is active when the macro is executed. I have tried creating a named range, and generating a macro, but always lose the focus of the starting cell...can anyone help resolve that problem?

Sub copyPaste()
Range("A1:F5").Copy
ActiveCell.PasteSpecial

End Sub

 

[Juan Pablo González]

Just a little simpler...

Range("A1:F5").Copy ActiveCell