copy paste named ranges?

[dtchang]

I'm trying to teach myself VBA from books and examples so please excuse the elementary level of this question but all i'm trying to do is copy one range from one place to another place in the same sheet.

so i wrote this...

Sub timepaste()

Dim myrange As Range

Set myrange = Range("c2:c5")
myrange = 50

Range("myrange").Copy


Range("h2").PasteSpecial

End Sub


which gives me an error of "method range of object global failed"

this code will fill out the range c2:c5 with the value of 50 but it wont copy or anything.

if i change the code to....


Sub timepaste()

Dim myrange As Range




Set myrange = Range("c2:c5")
myrange = 50

Range("c2:c5").Copy


Range("h2").PasteSpecial

End Sub


which all i did was replace the "myrange" with the actual "c2:c5" then everything works perfectly.

my question is, how can i tell it to copy "myrange" without typing the range because i feel that defeats the purpose of defining the range.

any insight would be great. Thanks in advance.

 

[Andrew Poulsom]

Welcome to MrExcel.

myrange is a Range object not a String, so:

myrange.Copy

 

[dtchang]

thank you very much!