Worksheet.function question

Hello,

My question:

When using the worksheet.function method in VBA, what code would one use to copy the result to all applicable cells in each applicable rows. My code is below:

Please Login or Register  to view this content.

I need the above result for M4, M5, M6, etc. and I don't want to right the above code multiple times for each row of data. Thanks.

Can you post a sample workbook?

How many rows are you trying to do this for?
You can do a simple loop or you can simply use a excel function for all of the cells then copy and paste values IF that is something you are looking for.

Please Login or Register  to view this content.

Thanks mT,

Your formula works perfectly. I was under the impression that using the "worksheet.function" property was the preferable method for adding Excel functions when doing VBA. Is that incorrect?

So your command entered the value of the sum formula, where my command entered the actual formula into the cells.