Selection as String

Hi.

I have created a macro in Excel which have a Form. The form contains among other things a RefEdit. When I launch the macro this RefEdit is empty, but I want it to contain for example Sheet1!$F$2:$F$9 as the default value if these cells are selected in the active sheet.

So what I need to know is if there is a way to get the selected range/cell(s) as a string representation.

Pseudo code:
-----------------------------

Public Sub MyMacro()
  Dim MyRefString As String

  ' Start of getting Selection as String-->
    MyRefString = ...
  '<-- End of getting Selection as String

  With MyForm
    .MyRefEdit.Value = MyRefString
  End With
...
End Sub

-------------------------------

Any ideas?

/Jörgen