| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro
Hi there!
Can anyone please inform how I can built a macro to apply a formula to some cells? In other words, I need a button to click on it and have below formula applied from cell M13 until the last data in the same column M. Formula is: =IF(OR(L13="40HC";L13="40RH");K13*2,25;IF(LEFT(L13 ;2)="40";K13*2;K13)) Thanks a lot. Gustavo. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro
set rng = Range("L13",Range("L13").End(xldown)).offset(0,1)
rng.formula = "=IF(OR(L13=""40HC"",L13=""40RH""),K13*2,25,IF(LEF T(L13,2)=""40"",K13*2,K13))" -- Regards, Tom Ogilvy "Gustavo Strabeli" wrote: Hi there! Can anyone please inform how I can built a macro to apply a formula to some cells? In other words, I need a button to click on it and have below formula applied from cell M13 until the last data in the same column M. Formula is: =IF(OR(L13="40HC";L13="40RH");K13*2,25;IF(LEFT(L13 ;2)="40";K13*2;K13)) Thanks a lot. Gustavo. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro
Tom,
It's almost OK despite the fact that when I click on the button all the results in column M are #NAME? However, if I click on the formula bar, the result appears... Any idea? Tks. "Tom Ogilvy" escreveu na mensagem ... set rng = Range("L13",Range("L13").End(xldown)).offset(0,1) rng.formula = "=IF(OR(L13=""40HC"",L13=""40RH""),K13*2,25,IF(LEF T(L13,2)=""40"",K13*2,K13))" -- Regards, Tom Ogilvy "Gustavo Strabeli" wrote: Hi there! Can anyone please inform how I can built a macro to apply a formula to some cells? In other words, I need a button to click on it and have below formula applied from cell M13 until the last data in the same column M. Formula is: =IF(OR(L13="40HC";L13="40RH");K13*2,25;IF(LEFT(L13 ;2)="40";K13*2;K13)) Thanks a lot. Gustavo. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro
Tools/Options/Calculations
are your calculation setting set to manual/Automatic? "Gustavo Strabeli" wrote: Tom, It's almost OK despite the fact that when I click on the button all the results in column M are #NAME? However, if I click on the formula bar, the result appears... Any idea? Tks. "Tom Ogilvy" escreveu na mensagem ... set rng = Range("L13",Range("L13").End(xldown)).offset(0,1) rng.formula = "=IF(OR(L13=""40HC"",L13=""40RH""),K13*2,25,IF(LEF T(L13,2)=""40"",K13*2,K13))" -- Regards, Tom Ogilvy "Gustavo Strabeli" wrote: Hi there! Can anyone please inform how I can built a macro to apply a formula to some cells? In other words, I need a button to click on it and have below formula applied from cell M13 until the last data in the same column M. Formula is: =IF(OR(L13="40HC";L13="40RH");K13*2,25;IF(LEFT(L13 ;2)="40";K13*2;K13)) Thanks a lot. Gustavo. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro
They're set as automatic.
It's strange because when I put the cursor in the formula bar, the result appears, but I have to do it cell by cell. "steve_doc" escreveu na mensagem ... Tools/Options/Calculations are your calculation setting set to manual/Automatic? "Gustavo Strabeli" wrote: Tom, It's almost OK despite the fact that when I click on the button all the results in column M are #NAME? However, if I click on the formula bar, the result appears... Any idea? Tks. "Tom Ogilvy" escreveu na mensagem ... set rng = Range("L13",Range("L13").End(xldown)).offset(0,1) rng.formula = "=IF(OR(L13=""40HC"",L13=""40RH""),K13*2,25,IF(LEF T(L13,2)=""40"",K13*2,K13))" -- Regards, Tom Ogilvy "Gustavo Strabeli" wrote: Hi there! Can anyone please inform how I can built a macro to apply a formula to some cells? In other words, I need a button to click on it and have below formula applied from cell M13 until the last data in the same column M. Formula is: =IF(OR(L13="40HC";L13="40RH");K13*2,25;IF(LEFT(L13 ;2)="40";K13*2;K13)) Thanks a lot. Gustavo. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro
"=IF(OR(L13=""40HC"",L13=""40RH""),K13*2,25,IF(LEF T(L13,2)=""40"",K13*2,K13))"
should have the comma in 2,25 changed to a period 2.25 I don't know if that will help. -- Regards, Tom Ogilvy "Gustavo Strabeli" wrote: Tom, It's almost OK despite the fact that when I click on the button all the results in column M are #NAME? However, if I click on the formula bar, the result appears... Any idea? Tks. "Tom Ogilvy" escreveu na mensagem ... set rng = Range("L13",Range("L13").End(xldown)).offset(0,1) rng.formula = "=IF(OR(L13=""40HC"",L13=""40RH""),K13*2,25,IF(LEF T(L13,2)=""40"",K13*2,K13))" -- Regards, Tom Ogilvy "Gustavo Strabeli" wrote: Hi there! Can anyone please inform how I can built a macro to apply a formula to some cells? In other words, I need a button to click on it and have below formula applied from cell M13 until the last data in the same column M. Formula is: =IF(OR(L13="40HC";L13="40RH");K13*2,25;IF(LEFT(L13 ;2)="40";K13*2;K13)) Thanks a lot. Gustavo. |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro
Tried it already, but without sucess...
By chance do you know what the cause would be? "Tom Ogilvy" escreveu na mensagem ... "=IF(OR(L13=""40HC"",L13=""40RH""),K13*2,25,IF(LEF T(L13,2)=""40"",K13*2,K13))" should have the comma in 2,25 changed to a period 2.25 I don't know if that will help. -- Regards, Tom Ogilvy "Gustavo Strabeli" wrote: Tom, It's almost OK despite the fact that when I click on the button all the results in column M are #NAME? However, if I click on the formula bar, the result appears... Any idea? Tks. "Tom Ogilvy" escreveu na mensagem ... set rng = Range("L13",Range("L13").End(xldown)).offset(0,1) rng.formula = "=IF(OR(L13=""40HC"",L13=""40RH""),K13*2,25,IF(LEF T(L13,2)=""40"",K13*2,K13))" -- Regards, Tom Ogilvy "Gustavo Strabeli" wrote: Hi there! Can anyone please inform how I can built a macro to apply a formula to some cells? In other words, I need a button to click on it and have below formula applied from cell M13 until the last data in the same column M. Formula is: =IF(OR(L13="40HC";L13="40RH");K13*2,25;IF(LEFT(L13 ;2)="40";K13*2;K13)) Thanks a lot. Gustavo. |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro
Tom,
I made it! My excel is in Portuguese and I was inserting the function "IF(OR...." in Portuguese, but as one last trial, I changed it to English and it worked! Thanks a lot for your help. Gustavo. "Gustavo Strabeli" escreveu na mensagem ... Tried it already, but without sucess... By chance do you know what the cause would be? "Tom Ogilvy" escreveu na mensagem ... "=IF(OR(L13=""40HC"",L13=""40RH""),K13*2,25,IF(LEF T(L13,2)=""40"",K13*2,K13))" should have the comma in 2,25 changed to a period 2.25 I don't know if that will help. -- Regards, Tom Ogilvy "Gustavo Strabeli" wrote: Tom, It's almost OK despite the fact that when I click on the button all the results in column M are #NAME? However, if I click on the formula bar, the result appears... Any idea? Tks. "Tom Ogilvy" escreveu na mensagem ... set rng = Range("L13",Range("L13").End(xldown)).offset(0,1) rng.formula = "=IF(OR(L13=""40HC"",L13=""40RH""),K13*2,25,IF(LEF T(L13,2)=""40"",K13*2,K13))" -- Regards, Tom Ogilvy "Gustavo Strabeli" wrote: Hi there! Can anyone please inform how I can built a macro to apply a formula to some cells? In other words, I need a button to click on it and have below formula applied from cell M13 until the last data in the same column M. Formula is: =IF(OR(L13="40HC";L13="40RH");K13*2,25;IF(LEFT(L13 ;2)="40";K13*2;K13)) Thanks a lot. Gustavo. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
| Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
| how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
| macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
| Start Macro / Stop Macro / Restart Macro | Excel Programming | |||
Hybrid Mode
