Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error when using macro to write formula to cell
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error when using macro to write formula to cell
Hi
try ActiveCell.FormulaR1C1 = "=IF(RC[-7]<0.25,"""",RC[-7]-TIME(0,16,0))" -- Regards Frank Kabel Frankfurt, Germany Patti wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error when using macro to write formula to cell
Patti,
Try ActiveCell.FormulaR1C1 = "=IF(RC[-7]<0.25,"""",RC[-7]-TIME(0,16,0))" Note that additional quotes inside the formula. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Patti" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error when using macro to write formula to cell
Frank, that extra set of quotes did the trick. Thank you very much - I
never would have come up with that on my own! Patti "Frank Kabel" wrote in message ... Hi try ActiveCell.FormulaR1C1 = "=IF(RC[-7]<0.25,"""",RC[-7]-TIME(0,16,0))" -- Regards Frank Kabel Frankfurt, Germany Patti wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |