Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Something that would tell me how e.g.
Application.ScreenUpdating = False LastRow = Range("F" & Rows.Count).End(xlUp).Row For r = LastRow To 2 Step -1 ' Headings in row 1 If Cells(r, "F").Value = "Closed" Then Rows(r).Copy Destination:=Sheets _ ("Interim").Range("A2").Offset(off, 0) Rows(r).Delete off = off + 1 End If Next Application.ScreenUpdating = True End Sub Would be made/explained Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Recommend template for expenses | New Users to Excel | |||
Can anyone recommend a reference book | Excel Worksheet Functions | |||
Can someone recommend an Excel VBA Book? | Excel Discussion (Misc queries) | |||
Recommend books | Excel Worksheet Functions | |||
Can anyone recommend a good book? | Excel Programming |