SUMIF In VBA

[jo15765]

I have this worksheet function that sums just like I need it. I need a way of VBA syntax to fill down to the last wrow in column E - matching on the new cell

Please Login or Register  to view this content.

And of course as the vba copied the formula down I would want it to iterate, B2, B3, B4, B5 etc etc

How does this get acomplished in Excel 2013 VBA/

[TMS]

Please Login or Register  to view this content.

[davsth]

you need to say what determines the last row which column has the entry in?

[jo15765]

@TMS - that formula just writes the formula to each cell. If I add in a "=" at the beginning of the formula I then get a error of application defined or object defined error.

@davsth - the last column that has data in it should be the last column in column A that has data. Sorry I did not make this clear initially.

[davsth]

Please Login or Register  to view this content.

[jo15765]

Please Login or Register  to view this content.

Thank you for that syntax - unfortunately this just writes the formula to the cell not the actual value the formula returns.

[TMS]

Sorry ...

Please Login or Register  to view this content.

[jo15765]

@TMS - that got it, thanks again

[TMS]

You're welcome.