Setting a range from a workbook VBA

Question

I'm trying to set a range for a Vlookup from another workbook but I keep receiving 424 Object Required Errors and I can't see why

Sub DosiDo()
Dim table1 As Range
Set table1 = Workbooks(210721 - LeaveRecords.xlsm).Sheets(Sheet1).Range(Cells(2, 2), Cells(7, 9))
End Sub

score 0 · Accepted Answer · answered Jul 23 '21 at 02:34

0

Missing double quotes:

Sub DosiDo()
    Dim table1 As Range
    Set table1 = Workbooks("210721 - LeaveRecords.xlsm").Sheets("Sheet1").Range(Cells(2, 2), Cells(7, 9))
End Sub

answered Jul 23 '21 at 02:34

Gary's Student

95,722
10
59
99

Thanks, so much! However, now I'm getting a 1004 application-defined or object-defined error, do you know why? – Nick Christensen Jul 23 '21 at 02:46
@NickChristensen Most likely problem is the spelling of the workbook name. **Check those spaces.** – Gary's Student Jul 23 '21 at 02:54
1

The problem is because of [Why does Range work, but not Cells?](https://stackoverflow.com/questions/17733541/why-does-range-work-but-not-cells) – Siddharth Rout Jul 23 '21 at 04:44

Setting a range from a workbook VBA

1 Answers1