|
|
#1
08-31-2018, 03:25 PM
|
|||
|
|||
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. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Entering a column value in a cell, to be used as part of a reference in a formula in another cell
|
paulkaye | Excel | 4 | 02-26-2017 04:18 AM |
| entering name in outlook does not autofill | Franksplace2 | Word | 0 | 03-08-2015 04:10 PM |
|
entering duration in months
|
ketanco | Project | 1 | 12-17-2014 01:09 PM |
|
entering lump sum costs
|
ketanco | Project | 1 | 12-24-2011 12:56 PM |
| Entering Contact details | GemmaD | Outlook | 0 | 12-18-2008 06:41 AM |
Windows 10 
Office 2016
Threaded Mode