Thread: Entering Formula in VB
View Single Post
 
Old 08-31-2018, 03:25 PM
Khwaja Khwaja is offline Windows 10 Office 2016
Novice
  
Join Date: Aug 2018
Posts: 12
Khwaja is on a distinguished road
Default Entering Formula in VB
I am trying to use the following formula as part of the code, but i keep getting error 1004. Application defined or object defined eror.

Range("K3").Formula = "=IF(H2="","",IF(AND(H2>TIMEVALUE(""5:00""),E2<TIM EVALUE(""9:00 AM"")),""10:00 AM"", IF(AND(H2>TIMEVALUE(""5:00""),E2>TIMEVALUE(""9:00 AM"")),""12:00 PM"","")))"

Will appreciate some help.
Reply With Quote