Guest User

Untitled

a guest
May 23rd, 2018
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.64 KB | None | 0 0
  1. Dim LastColFcst As Integer
  2. For Each p In Range("E44:P44,S44:AD44,AG44:AR44,AU44:BF44,BI44:BU44")
  3. If p.Value <> 0 And p.Offset(-35, 0).Value = "Forecast" Then
  4. LastColFcst = p.Column
  5. End If
  6. Next p
  7.  
  8. Dim LastColFcst As Integer
  9. For Each p In Range("E86:P86,S86:AD86,AG86:AR86,AU86:BF86,BI86:BU86")
  10. If p.Value <> 0 And p.Offset(-35, 0).Value = "Forecast" Then
  11. LastColFcst = p.Column
  12. End If
  13. Next p
  14.  
  15.  
  16. For Each L In Range("E88:P88,S88:AD88,AG88:AR88,AU88:BF88,BI88:BU88")
  17. If L.Value <> 0 And L.Offset(-35, 0).Value = "Forecast" And L.Column > LastColFcst Then
  18. LastColFcst = L.Column
  19. End If
  20. Next L
Add Comment
Please, Sign In to add comment