Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I insert formulas into my macros?
I tried recording some formulas into a macro, but this doesn't work. Is it
possible to do so, without using Visual Basic programming? Can it be done using Visual Basic programming - I am not an expert :-) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I insert formulas into my macros?
Sarah,
You can record formula entry with the macro recorder:- ActiveCell.Formula = "=SUM(A3:A9)" ActiveCell.FormulaR1C1 = "=SUM(RC[-1]:R[6]C[-1])" These 2 formula are the same, they are in B3 and add up A3 to A9. The first is entered manually and the second is the recorded version of the same thing. What precisely are you trying to do? Mike "Sarah" wrote: I tried recording some formulas into a macro, but this doesn't work. Is it possible to do so, without using Visual Basic programming? Can it be done using Visual Basic programming - I am not an expert :-) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I insert formulas into my macros?
Hi Mike,
Thanks for your quick answer ! In fact, I tried recording the copying a formula I created earlier in another workbook (this one below) =IF(ISERROR(LEFT(F2;FIND(200;F2)-1));F2;(LEFT(F2;FIND(200;F2)-1))) it replaces a word, with a number after the word starting by 200, by only the word because I always have to do this when I create the updated version of the same report. Are you saying that it is necessary to insert the formula manually for it to be recorded by a macro, and that I can not copy the formula from another worksheet? Sarah "Mike H" wrote: Sarah, You can record formula entry with the macro recorder:- ActiveCell.Formula = "=SUM(A3:A9)" ActiveCell.FormulaR1C1 = "=SUM(RC[-1]:R[6]C[-1])" These 2 formula are the same, they are in B3 and add up A3 to A9. The first is entered manually and the second is the recorded version of the same thing. What precisely are you trying to do? Mike "Sarah" wrote: I tried recording some formulas into a macro, but this doesn't work. Is it possible to do so, without using Visual Basic programming? Can it be done using Visual Basic programming - I am not an expert :-) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I insert formulas into my macros?
Sarah,
I can see what you formula does but I'm not sure what the question is, take these 2 examples Range("F3").Formula = "=IF(ISERROR(LEFT(F2,FIND(200,F2)-1)),F2,(LEFT(F2,FIND(200,F2)-1)))" Range("F3").Formula = Sheets("Sheet1").Range("F5").Formula The first puts you formula into F3 and the second copies your fromula from F5 to F3 Note i've changed ; to , for my version of Excel Mike "Sarah" wrote: Hi Mike, Thanks for your quick answer ! In fact, I tried recording the copying a formula I created earlier in another workbook (this one below) =IF(ISERROR(LEFT(F2;FIND(200;F2)-1));F2;(LEFT(F2;FIND(200;F2)-1))) it replaces a word, with a number after the word starting by 200, by only the word because I always have to do this when I create the updated version of the same report. Are you saying that it is necessary to insert the formula manually for it to be recorded by a macro, and that I can not copy the formula from another worksheet? Sarah "Mike H" wrote: Sarah, You can record formula entry with the macro recorder:- ActiveCell.Formula = "=SUM(A3:A9)" ActiveCell.FormulaR1C1 = "=SUM(RC[-1]:R[6]C[-1])" These 2 formula are the same, they are in B3 and add up A3 to A9. The first is entered manually and the second is the recorded version of the same thing. What precisely are you trying to do? Mike "Sarah" wrote: I tried recording some formulas into a macro, but this doesn't work. Is it possible to do so, without using Visual Basic programming? Can it be done using Visual Basic programming - I am not an expert :-) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macros to insert specific rows without altering the formula | Excel Discussion (Misc queries) | |||
using formulas in macros | Excel Discussion (Misc queries) | |||
Trouble using macros to insert rows | Excel Discussion (Misc queries) | |||
formulas vs macros | Excel Discussion (Misc queries) | |||
Macros/Formulas | Excel Worksheet Functions |