simple vba code gives me run time error 91 object variable or with block not set

Question

So I have a simple little macro sub defined when a command button is clicked  The problem is it gives me  Run Time Error  91    Object Variable or With Block not Set My code is  Dim rng As Range rng   Sheet8 Range  quot A12 quot     lt  lt  ERROR here rng Value2    quot 1 quot   I just want to set Cell  quot A12 quot  in Sheet8   Thanks

User · Accepted Answer

You need Set with objects    Set rng   Sheet8 Range  A12     Sheet8 is fine    Sheet1  a1

User · Answer

Check the version of the excel  if you are using older version then Value2 is not available for you and thus it is showing an error  while it will work with 2007  version  Or the other way  the object is not getting created and thus the Value2 property is not available for the object

User · Answer

Also you are trying to set value2 using Set keyword  which is not required  You can directly use rng value2   1 below test code for ref  Sub test       Dim rng As Range     Set rng   Range  quot A1 quot       rng Value2   1 End Sub

[vba] simple vba code gives me run time error 91 object variable or with block not set

Examples related to vba

Examples related to excel

Examples related to excel-2007