excel - simple vba code gives me run time error 91 object variable or ...

You need Set with objects: Set rng = Sheet8.Range("A12"). Sheet8 is fine. Sheet1.[a1] ...

stackoverflow.com