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