sum of cells where row number is a variable

[coopedup]

Hi,

In my scenario I have a project number then a lot of figures associated. I'm using a macro to find my chosen project number and from there I want to sum certain cells on that row.

Please Login or Register  to view this content.

I get the row number but I've tried different approaches to get a sum of the cells I need.

Where am I going wrong??

Thanks, Neil

[Pete_UK]

Try:

Please Login or Register  to view this content.

and so on.

Hope this helps.

Pete

[coopedup]

Hi,

Thanks for replying.

Please Login or Register  to view this content.

When I run the macro I get a compiler error that reports Sum as "Sub or Function not defined". Sum is a standard function and Support is already defined. Any pointers?

[coopedup]

Hi,

Thanks for replying.

Please Login or Register  to view this content.

When I run the macro I get a compiler error that reports Sum as "Sub or Function not defined". Sum is a standard function and Support is already defined. Any pointers?

[Jonmo1]

Try

Application.Sum(......

[coopedup]

Bing....thank you Pete and Jonmo, your help was great.

Neil