Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Dim LastColFcst As Integer
- For Each p In Range("E44:P44,S44:AD44,AG44:AR44,AU44:BF44,BI44:BU44")
- If p.Value <> 0 And p.Offset(-35, 0).Value = "Forecast" Then
- LastColFcst = p.Column
- End If
- Next p
- Dim LastColFcst As Integer
- For Each p In Range("E86:P86,S86:AD86,AG86:AR86,AU86:BF86,BI86:BU86")
- If p.Value <> 0 And p.Offset(-35, 0).Value = "Forecast" Then
- LastColFcst = p.Column
- End If
- Next p
- For Each L In Range("E88:P88,S88:AD88,AG88:AR88,AU88:BF88,BI88:BU88")
- If L.Value <> 0 And L.Offset(-35, 0).Value = "Forecast" And L.Column > LastColFcst Then
- LastColFcst = L.Column
- End If
- Next L
Add Comment
Please, Sign In to add comment