Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
When typed directly in cell L11, this formula does what I want:
=IF(E11<0.25,"",E11-TIME(0,16,0)) When I go to the Immediate Window and type ? range ("L11").FormulaR1C1, the following is returned: =IF(RC[-7]<0.25,"",RC[-7]-TIME(0,16,0)) So I tried to create a procedure using that - Range("L11").Activate ActiveCell.FormulaR1C1 = "=IF(RC[-7]<0.25,"",RC[-7]-TIME(0,16,0))" .... and get the error "Run-time error '1004': Application-defined or object-defined error" Can anyone tell me what I am doing wrong? TIA, Patti |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Use macro to write formula | Excel Discussion (Misc queries) | |||
How do I write an Excel macro when the cell range changes weekly? | Excel Discussion (Misc queries) | |||
is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data? | Excel Worksheet Functions | |||
How to write a formula that will prevent appearance ERROR MESSAGE | Excel Worksheet Functions | |||
Question: Cell formula or macro to write result of one cell to another cell | Excel Programming |