View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] simonlavender@gmail.com is offline
external usenet poster
 
Posts: 11
Default What VBA learnign bokos would you recommend? (Available in the UK)

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