Thread: Entering Formula in VB
View Single Post
 
Old 08-31-2018, 09:38 PM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
  
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default
Try
Code:
Range("K3").Formula = "=IF(H2="""","""",IF(AND(H2>TIMEVALUE(""5:00""),E2<TIMEVALUE(""9:00 AM"")),""10:00 AM"", IF(AND(H2>TIMEVALUE(""5:00""),E2>TIMEVALUE(""9:00 AM"")),""12:00 PM"","""")))"
Reply With Quote