I have this code for which I'm trying to define a range to search in, but it gives me the runtime error above.
What I'm trying to accomplish is to open ANOTHER spreadsheet, search for a value and paste other values based on that.
Dim wb As Workbook
Set wb = Workbooks.Open("c:\Original.xlsx")
Set ws2 = wb.Sheets("FS_ITEM")
I've tried a smaller range, different sheets, books etc. Must be something I've overlooked.