S
Shakespear
Hi.
I have created a macro in Excel which have a Form. The form contain
among other things a RefEdit. When I launch the macro this RefEdit i
empty, but I want it to contain for example Sheet1!$F$2:$F$9 as th
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 selecte
range/cell(s) as a string representation.
Pseudo code:
-----------------------------
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
I have created a macro in Excel which have a Form. The form contain
among other things a RefEdit. When I launch the macro this RefEdit i
empty, but I want it to contain for example Sheet1!$F$2:$F$9 as th
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 selecte
range/cell(s) as a string representation.
Pseudo code:
-----------------------------
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