Trying to word this correctly within my "This Workbook"..
Private Sub Workbook_Open()
Worksheet("symbol list").Select
With Selection IF(TODAY()>K1,Application.Run "Add_Days_Ranking","")
End Sub
'K1 being a DATE..either yesterdays,todays, Fridays..
-------------
Basically what I need is for the Macro to run if its the next day (run only 1time), also exclude SAT/SUNS from running this Macro...thanks
Private Sub Workbook_Open()
Worksheet("symbol list").Select
With Selection IF(TODAY()>K1,Application.Run "Add_Days_Ranking","")
End Sub
'K1 being a DATE..either yesterdays,todays, Fridays..
-------------
Basically what I need is for the Macro to run if its the next day (run only 1time), also exclude SAT/SUNS from running this Macro...thanks