Setting a variable problem

[argue19]

I am trying to get a value from a cell on another worksheet (within the same workbook) and assign it to the variable. I get the following error:

-- removed inline image ---


Here's my code:
Sub x()
Dim x As Double
x = Worksheets("Home").Range(R3C2)
ActiveCell.Offset(0, 3).Value = x
End Sub

Thanks

 

[kpark91]

Try

Sub kpark91()
    Dim x As Double
    x = CDbl(Worksheets("Home").Range("B3").Value)
    ActiveCell.Offset(0, 3).Value = x
End Sub

 

[argue19]

Guess it's a problem using R1C1 reference. Solved it with A1 style. Stiill would appreciate suggestions as I often sue R1C1 references.

 

[kpark91]

You would have to use Cells then..
If you want R3C2

Cells(3, 2).Value would be the way.