When I do as suggested or at least i hope I did, i get an error
debug.jpg
Please correct this if it is wrong....
thanks SamTOption Explicit Sub NumbersGrabber() Dim InputSht As Worksheet Dim DrnNumSht As Worksheet Static NextRowToUse As Long 'maintains State between calls as long as Workbook is open. With caveats. Set InputSht = Sheets("Input") Set DrnNumSht = Sheets("Drawn Numbers") If NextRowToUse = 0 Then NextRowToUse = 2500 If NextRowToUse = 1 Then Exit Sub DrnNumSht.Cells(NextRowToUse, "I").Resize(, 7).Copy 'Resize(0 Rows, 7 Columns) InputSht.Range("I49").Resize(, 7).Insert shift:=xlShiftDown NextRowToUse = NextRowToUse - 1 ertert 'Run the etert Procedure NumbersGrabber 'get more numbers End Sub




Reply With Quote