amhiddema
09-20-2009, 11:43 PM
Through a VBA code a cell is manuallu selected. I would like to capture the position of the selected cell into VBA as I'm trying to do in the code. I need the strings a and b to be filled. Unfortunately, it does not work. What am I doing wrong?
Sub Macro1()
Dim a As Integer, b As String, rRange As Range
Set rRange = Application.InputBox(Prompt:= _
"Please select a Cell", _
Title:="Select Cell", Type:=8)
SelectedCell = Cells(a, b)
End Sub
Sub Macro1()
Dim a As Integer, b As String, rRange As Range
Set rRange = Application.InputBox(Prompt:= _
"Please select a Cell", _
Title:="Select Cell", Type:=8)
SelectedCell = Cells(a, b)
End Sub