Copy range into active cell

[jeff p]

Hello

I have this code I wrote (combining variations of existing ones).. but not very well.
unfortunately doesn’t seem to work. It copies the information back onto itself

Please Login or Register  to view this content.

I’m trying to copy a simple Named Range “Range1” Into the active cell
Ie: This will be activated via button…Whatever cell is selected, by clicking the button will paste the information from the Named Range “Range1” into that active cell.

any ideas for improvement?

Thanks for any help

Jeff

[VBA Noob]

Maybe

Please Login or Register  to view this content.

VBA Noob

[jeff p]

Please Login or Register  to view this content.

worked great!

Thanks

[VBA Noob]

The one line does it all.

You don't need

Please Login or Register  to view this content.

VBA Noob

[jeff p]

Indeed,

...far better than my nonsense..

thanks!

[VBA Noob]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save