Hi Theresa,
There isn't a SUM function in VBA.
You can use application.worksheetfunction.sum(1,2,3,4).

Or do it the easy way.
=1+2+3+4



--
John
johnf 202 at hotmail dot com


"Theresa Simpson" wrote in message
...
| Hello:
|
| I am trying to use the sum function in a VBA module in an
| excel 2002 worksheet. When my code runs, it seems to not
| recognize the "Sum" function. Any suggestions as to why
| it is not being recognized would be appreciated. Is
| there a small line of code that I might be missing that
| would allow me to use this or any function?
|
| Thanks,
|
| Theresa