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

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

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

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