(by the way - this is a duplicate post because I left out the title in the first post - sorry!)
Trying to copy UsedRange and paste to "destination" sheet - thought it would be cleaner. Copying from UsedRange range in wb_IGQty Workbook to workbook containing macro (ThisWorkbook). I'm failing with error 438 "Object does not support this property or method". This approach appeared cleaner than my old code so I tried something new. Questions: (1) what is wrong with the code, and (2) should I deep-six this approach. (I'm failing in the last line of code below - also failed without the .Paste). Thanks in advance for your thoughts...
Trying to copy UsedRange and paste to "destination" sheet - thought it would be cleaner. Copying from UsedRange range in wb_IGQty Workbook to workbook containing macro (ThisWorkbook). I'm failing with error 438 "Object does not support this property or method". This approach appeared cleaner than my old code so I tried something new. Questions: (1) what is wrong with the code, and (2) should I deep-six this approach. (I'm failing in the last line of code below - also failed without the .Paste). Thanks in advance for your thoughts...
Rich (BB code):
debugger = 51
Set wb_IGQty = Workbooks.Open(“\\ICSBS\RedirectedFolders\me\My Documents\IGQty.xlsx”)
debugger = 52
Dim tosheet As Worksheet
debugger = 53
Set tosheet = ThisWorkbook.Worksheets(“Inv”)
debugger = 54
ActiveSheet.UsedRange.Copy Destination:=tosheet(“A600”).Paste