Copy range to clipboard

Question

I would like to copy a range (specified in the VBA code: A1:I1) into the clipboard, so that the user can paste it whereever he like. How could I do this?

Answer 1

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

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