Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula in a macro
I am running a macro in a workbook that finds the first empty row in a range,
then I have the pointer move to the next column (L) and up one. I need to put a formula in that cell "=sum(K1:K45)". When I run the macro I am getting a result in the cell "#NAME?" and the formula shows as "=SUM('K1':'K45')" Can anyone help on how to correctly input the formula in the macro. Thanks Linda |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula in a macro
Those apostrophes around the cell addresses shouldn't be there. It would
help if you showed us the code you are using to assign the formula. Rick "mathel" wrote in message ... I am running a macro in a workbook that finds the first empty row in a range, then I have the pointer move to the next column (L) and up one. I need to put a formula in that cell "=sum(K1:K45)". When I run the macro I am getting a result in the cell "#NAME?" and the formula shows as "=SUM('K1':'K45')" Can anyone help on how to correctly input the formula in the macro. Thanks Linda |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula in a macro
In your code you should have something like this if your formula is in K46:
Range("K46").FormulaR1C1 = "=SUM(R[-45]C:R[-1]C)" Note that this is a Row Column Reference. -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "Rick Rothstein (MVP - VB)" wrote: Those apostrophes around the cell addresses shouldn't be there. It would help if you showed us the code you are using to assign the formula. Rick "mathel" wrote in message ... I am running a macro in a workbook that finds the first empty row in a range, then I have the pointer move to the next column (L) and up one. I need to put a formula in that cell "=sum(K1:K45)". When I run the macro I am getting a result in the cell "#NAME?" and the formula shows as "=SUM('K1':'K45')" Can anyone help on how to correctly input the formula in the macro. Thanks Linda |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula in a macro
Hi Linda -
After your code moves the pointer to the proper cell, run this statement (it uses the A1-style reference): Selection.Formula = "=sum(K1:K45)" ------ Jay "mathel" wrote: I am running a macro in a workbook that finds the first empty row in a range, then I have the pointer move to the next column (L) and up one. I need to put a formula in that cell "=sum(K1:K45)". When I run the macro I am getting a result in the cell "#NAME?" and the formula shows as "=SUM('K1':'K45')" Can anyone help on how to correctly input the formula in the macro. Thanks Linda |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
help with the macro or with the formula | Excel Worksheet Functions | |||
Formula in macro causes macro to fail | Excel Programming | |||
macro or formula | Excel Programming | |||
Formula expected end of statement error, typing formula into cell as part of VBA macro | Excel Programming | |||
Formula & Macro | Excel Programming |