| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application-defined or object-defined error
I am getting the above error message on the code line below and I can't
figure it out. MScell is a string variable that evaluates to "J". I would appreciate any insight into this. Thanks. Me.Range("H6").Formula = "=IF(TODAY()=$B6,SUMPRODUCT(--(Actualized!$B$16:$B$1056=$B$3),--(Actualized!$" & MScell & "$16:$" & MScell & "$1056<=$B6)),"")" |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Application-defined or object-defined error
Replace the double quotes to denote blank within the formula ("") with """"
as below Me.Range("H6").Formula = "=IF(TODAY()=$B6,SUMPRODUCT(--(Actualized!$B$16:$B$1056=$B$3),--(Actualized!$" & MScell & "$16:$" & MScell & "$1056<=$B6)),"""")" -- If this post helps click Yes --------------- Jacob Skaria "Ayo" wrote: I am getting the above error message on the code line below and I can't figure it out. MScell is a string variable that evaluates to "J". I would appreciate any insight into this. Thanks. Me.Range("H6").Formula = "=IF(TODAY()=$B6,SUMPRODUCT(--(Actualized!$B$16:$B$1056=$B$3),--(Actualized!$" & MScell & "$16:$" & MScell & "$1056<=$B6)),"")" |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Application-defined or object-defined error
Thanks Jacob. It worked.
"Jacob Skaria" wrote: Replace the double quotes to denote blank within the formula ("") with """" as below Me.Range("H6").Formula = "=IF(TODAY()=$B6,SUMPRODUCT(--(Actualized!$B$16:$B$1056=$B$3),--(Actualized!$" & MScell & "$16:$" & MScell & "$1056<=$B6)),"""")" -- If this post helps click Yes --------------- Jacob Skaria "Ayo" wrote: I am getting the above error message on the code line below and I can't figure it out. MScell is a string variable that evaluates to "J". I would appreciate any insight into this. Thanks. Me.Range("H6").Formula = "=IF(TODAY()=$B6,SUMPRODUCT(--(Actualized!$B$16:$B$1056=$B$3),--(Actualized!$" & MScell & "$16:$" & MScell & "$1056<=$B6)),"")" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Run-time error '50290': Application-defined or object-defined erro | Excel Discussion (Misc queries) | |||
| Export a chart in a GIF file. Run-time error '1004': Application-defined or object-defined error; | Excel Programming | |||
| Copying A Range of Cells From one Sheet to Another - Error Application Defined or Object Defined | Excel Programming | |||
| Runtime error 1004- application defined or object defined erro | Excel Programming | |||
| Runtime error 1004- application defined or object defined erro | Excel Programming | |||
Linear Mode
