Forgot the Title Block - should have been "ActiveSheet.UsedRange.Copy Destination:=tosheet(“A600”).Paste Failure
Trying to copy used range and paste to "destination" sheet - thought it would be cleaner. Copying from used range in wb_IGQty to workbook containing macro (ThisWorkbook). 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. (Failing in the last line of code below - also failed without the .Paste). Thanks in advance for your thoughts...
Trying to copy used range and paste to "destination" sheet - thought it would be cleaner. Copying from used range in wb_IGQty to workbook containing macro (ThisWorkbook). 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. (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
Last edited: