I have a macro that I need to add a few calculating rows to that will then have a summary total row for the calculations above. I have my search names in Column B and am trying to enter the final calculation row in Column I. My macro is working fine upto the point that I am selecting the cell to insert this formula into. No row numbers can be used as this will be a floating calculations based on "LAST ROW"
This is the formula I was able to get from using the function options w/in excel and just having the formula in the cell. However, when I try to add it to my VB code, it does not work. I'm getting an error at the colon that is between the I column.
ActiveCell.Formula =SUMIFS(I:I,B:B,"Adjustments")+SUMIFS(I:I,B:B,"Direct Hire")+SUMIFS(I:I,B:B,"Grand Total")
I'm just not seeing why the code won't work in the VBA part.