Assigning a cell using variables VBA

[LRoy]

Hello,

I'm currently learning the basics of VBA so I'm aware the solution to this is probably quite obvious.

With the above, I'm expecting to see the value for the variable z placed into the cell which has been determined by the user.
The code runs through fine without any errors, however the value for z is not being placed into the designated cell.
If I remove the variables x and y for Range, and just type a normal cell reference e.g. ("A1") then it works perfectly.
I'm aware that the error lies somewhere within the Range("x" & y) = z but I can't figure it out.
Any help would be appreciated.

 

[Phuoc]

Try this:

Range(x & y ) = z

Or

Cells(y, x) = z

 

[LRoy]

Try this:

Range(x & y ) = z

Or

Cells(y, x) = z

The first solution solved it thank you! I thought because it was string it would have to be in the quotation marks.