Set Wb2 = Workbooks.Open(ThisWorkbook.Path & "\SAMPLE2.xlsm") this line has errors bcoz sample2.xlsm is already openedCode:Sub STEP6d() Dim Wb1 As Workbook, Wb2 As Workbook Set Wb1 = Workbooks.Open(ThisWorkbook.Path & "\SAMPLE1.xlsx") Set Wb2 = Workbooks.Open(ThisWorkbook.Path & "\SAMPLE2.xlsm") Dim Ws1 As Worksheet, Ws2 As Worksheet Set Ws1 = Wb1.Worksheets.Item(1) Set Ws2 = Wb2.Worksheets.Item(1)
plz let me know what i have to right in this line




Reply With Quote

Bookmarks