Copy a fixed selection to the current cell...

Todd K · Feb 28th, 2002, 05:15 PM

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 · Feb 28th, 2002, 05:19 PM

Quote:

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 · Mar 1st, 2002, 12:20 AM

Just a little simpler...

Range("A1:F5").Copy ActiveCell

Mar 1st, 2002, 12:20 AM	#3
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	Just a little simpler... Range("A1:F5").Copy ActiveCell __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 28th, 2002, 05:15 PM	#1
Todd K New Member Join Date: Feb 2002 Posts: 31	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?