Object Variable not set error, Visual Basic

Question

I keep on getting the following error in VBA

"Object Variable or With Block Variable not set"

I have no idea why

My code is

Private Sub Worksheet_Calculate()
    Dim RNG As Range
    RNG = Sheet1.Range("C15:D55,G11,G12,G15,G18,G19")
End Sub

The Sheet CodeName is correct.

Anyone have any ideas? Thanks

A `Range` is an Object type, you need to use `Set` statement for variable assignment. — Vincent G, Apr 03 '17 at 08:31

score 0 · Accepted Answer · answered Apr 03 '17 at 08:36

0

A Range type is an Object type, and must be assigned to with the Set statement:

Private Sub Worksheet_Calculate()
    Dim RNG As Range
    Set RNG = Sheet1.Range("C15:D55,G11,G12,G15,G18,G19")
End Sub

answered Apr 03 '17 at 08:36

ThunderFrame

1 Answers1