Copy range to clipboard

I would like to copy a range (specified in the VBA code: A1:I1) into t开发者_如何学Che clipboard, so that the user can paste it whereever he like. How could I do this?

Range has a Copy method on it, so to copy a range you can just do:

Sub Macro1()
    Range("A1:I1").Copy
End Sub