assigning a name to the active cell for use in a macro

**narlee** · 12-03-2010, 03:12 PM

Seems like it should be simple. Maybe it is.

I want to copy a range to the current cell. I might be at A10. Later I might be at A23. Regardless, I want to be able to copy a named range to the current cell. I want to put this command in a macro, so that I don't have to go scrolling thru the sheet to find the range, copy it, go back to where I was and paste it.

I have read about ActiveCell, but it doesn't seem as straightforward as it should be.

Thanks,
Geof Narlee

**mrice** · 12-03-2010, 03:51 PM

Paste the following into a new module in the VBA editor (Alt F11)

Sub PasteNamedRange()
Range("MyNamedRange").Copy Destination:=Selection
End Sub

Edit to put in the actual name of your range. You might then want to assign a shortcut key to the macro (CNTRL something) for speed of use.

**narlee** · 12-03-2010, 04:48 PM

OMG. I've been trying to figure that one out, on & off, for years.

THANK YOU SO MUCH, Martin.

Just noticed your London Marathon Cancer Run. Will be back next week to enter a donation. Thanks again & good luck on the Marathon.

Thread: assigning a name to the active cell for use in a macro

Thread Tools

Display

assigning a name to the active cell for use in a macro

Re: assigning a name to the active cell for use in a macro

Re: assigning a name to the active cell for use in a macro

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions