Code:Sub STEP7() Dim Wb1 As Workbook Dim wb3 As Workbook Dim Ws1 As Worksheet Dim ws3 As Worksheet Dim r As Long Dim m As Long Dim rng As Range Dim n As Long Application.ScreenUpdating = False Set Wb1 = Workbooks.Open("C:\Users\WolfieeeStyle\Desktop\1.xls") Set Ws1 = Wb1.Worksheets(1) m = Ws1.Range("B" & Ws1.Rows.Count).End(xlUp).Row Set wb3 = Workbooks.Open("C:\Users\WolfieeeStyle\Desktop\BasketOrder.xlsx") Set ws3 = wb3.Worksheets(1) Set rng = ws3.Range("C:C").Find(what:="*", searchorder:=xlByRows, SearchDirection:=xlPrevious) If rng Is Nothing Then n = 1 Else n = rng.Row + 1 End If For r = 2 To m ws3.Range("C" & n).Value = Ws1.Range("B" & r).Value n = n + 1 Next r Application.DisplayAlerts = False wb3.Close SaveChanges:=True Wb1.Close SaveChanges:=False Application.DisplayAlerts = True Application.ScreenUpdating = True End Sub
Problem Solved
Thnx Alot Doc Sir for helping me in solving this Problem
Have a Great Day




Reply With Quote

Bookmarks