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

by

You need Set with objects:

 Set rng = Sheet8.Range("A12")

Sheet8 is fine.

 Sheet1.[a1]

More Related Contents:

  1. Unprotect VBProject from VB code
  2. Assign event handlers to controls on user form created dynamically in VBA
  3. VBA: How to delete filtered rows in Excel?
  4. Round function in Excel, worksheet function vs VBA
  5. Excel VBA Userform – Execute Sub when something changes
  6. VBA Function argument list select
  7. Excel VBA wildcard search
  8. Reading Web Pages using Excel VBA
  9. to make this code simpler
  10. VBA code takes long time to execute in excel
  11. What is the lifetime of a global variable in excel vba?
  12. How to check for empty array in vba macro [duplicate]
  13. Use autofilter on more than 2 criteria
  14. What is the function of FormulaR1C1?
  15. Compiler Error: User-defined types not defined
  16. Open a workbook using FileDialog and manipulate it in Excel VBA
  17. Vba Excel do vlookup from a closed file
  18. excel hyperlink to nothing
  19. How to send files via HTTP_POST with Excel using VBA?
  20. How to Add Date Picker To VBA UserForm
  21. Vba macro to copy row from table if value in table meets condition
  22. Difference between Thisworkbook.name and Activeworkbook.name in VBA
  23. Set a cell value from a function
  24. How to determine if a date falls on the weekend?
  25. Calling regasm without administrative rights for COM interop in Excel VBA
  26. Is there a way for DIR(path) in VBA to handle strings longer than 260?
  27. How do I activate a specific workbook and a specific sheet?
  28. Delete all data rows from an Excel table (apart from the first)
  29. Start VBA macro when editing a cell
  30. Copy an entire worksheet to a new worksheet in Excel 2010

Leave a Comment