How do I activate a specific workbook and a specific sheet?

by

You do not need to activate the sheet (you’ll take a huge performance hit for doing so, actually). Since you are declaring an object for the sheet, when you call the method starting with “wb.” you are selecting that object. For example, you can jump in between workbooks without activating anything like here:

Sub Test()

Dim wb1 As Excel.Workbook
Set wb1 = Workbooks.Open("C:\Documents and Settings\xxxx\Desktop\test1.xls")
Dim wb2 As Excel.Workbook
Set wb2 = Workbooks.Open("C:\Documents and Settings\xxxx\Desktop\test2.xls")

wb1.Sheets("Sheet1").Cells(1, 1).Value = 24
wb2.Sheets("Sheet1").Cells(1, 1).Value = 24
wb1.Sheets("Sheet1").Cells(2, 1).Value = 54

End Sub

More Related Contents:

  1. VBA – How to grab the cell below if a cell has text?
  2. Excel VBA – A general how to
  3. VBA code required for Msg Box when two value equal in two cells
  4. Find text and show value if condition is met
  5. Excel check len string separated by comma [closed]
  6. How can I insert variable into formula in VBA
  7. Wait until ActiveWorkbook.RefreshAll finishes – VBA
  8. Code in VBA loops and never ends. How to fix this?
  9. Excel column number from column name
  10. Pop up the Excel Statusbar?
  11. VBA – destroy a modeless UserForm instance properly
  12. How To Speed Up VBA Code
  13. Execute a command in command prompt using excel VBA
  14. “Unable to get the VLookup property of the WorksheetFunction Class” error [duplicate]
  15. Copy data from another Workbook through VBA
  16. Excel VBA Load worksheet in Function
  17. Searching an excel with two search words (multiple lookup) using vba macro [closed]
  18. Excel VBA – Combine rows with duplicate values in one cell and merge values in other cell
  19. Load csv file into a VBA array rather than Excel Sheet
  20. Insert line break in wrapped cell via code
  21. Change color of certain characters in a cell
  22. Want VBA in excel to read very large CSV and create output file of a small subset of the CSV
  23. VBA Macro crashes after 32000 rows
  24. How to create dynamic variable names VBA
  25. How to break a long string into multiple lines
  26. Read VBA macros (or vbaProject.bin) of an Excel file without opening it in MS Excel [closed]
  27. simple vba code gives me run time error 91 object variable or with block not set
  28. Run-time error ’91’ (Object variable or With block variable not set)
  29. Loop through cells and add to a range
  30. Start VBA macro when editing a cell

Leave a Comment