Hi Guys!
I started this macro with
If NLP = 4 Then , and was not working.
Do you know why?
Thanks a lot
Detlef
Then I tried If NLP > 3 Then, and it worked
'Calculate the Coordinates for 4. Lower Pickets
If NLP > 3 Then
Worksheets("Sheet1").Range("A123").Value = "PLINE"
Worksheets("Sheet1").Range("B123").Value = (SPX + TSDLX + (4 * SLP) + (3 * TSPX)) & "," & (SPY + TSDBX + BPH + TSDMX)
Worksheets("Sheet1").Range("C123").Value = (SPX + TSDLX + (4 * SLP) + (4 * TSPX)) & "," & (SPY + TSDBX + BPH + TSDMX)
Worksheets("Sheet1").Range("D123").Value = (SPX + TSDLX + (4 * SLP) + (4 * TSPX)) & "," & (SPY + TSDBX + LDH)
Worksheets("Sheet1").Range("E123").Value = (SPX + TSDLX + (4 * SLP) + (3 * TSPX)) & "," & (SPY + TSDBX + LDH)
Worksheets("Sheet1").Range("F123").Value = "CLOSE"
End If
Bookmarks