Combining Defined Row and Defined Column

[BalbasNiBarabas]

Hello guys!

So I am a beginner in VBA. I am actually just starting. I am a taking a course on it. So I have encountered a problem in this case:

What I need to do is:
1. Input row number and column letter in a separate Input box.
2. Get a value from (2,2) of a selection.
3. Put that value from (2,2) to the defined row number and column.

In my local, I can do the item 1 and 2. However, I am having a difficulty on doing the 3rd one. Below is my code:

Sub Test()
Dim x As Integer, y As String, z As Double
x = InputBox("number:")
y = InputBox("letter:")
z = Selection(2, 2)
Range(x, y) = z
End Sub

I keep on having error on my range line. I how you can help me with this and give explanation.

Thanks!
BNB

 

[Fluff]

Hi & welcome to MrExcel.
Change it from Range to Cells.

 

[BalbasNiBarabas]

OMG @Fluff!!!

Thank you very much! It works perfectly. My new code is now:

Sub Test()
Dim x As Integer, y As String, z As Double
x = InputBox("number:")
y = InputBox("letter:")
z = Selection(2, 2)
Cells(x, y) = z
End Sub

 

[Fluff]

You're welcome & thanks for the feedback.