Hi again,
I have another excel formula that i need to convert into access vba that then creates the worksheet
the first one I needed was - Formula1:="=MOD(MINUTE(C8:F" & Mid(last_cell, 4, 3) & "),15)>0"
when converted into excel it looks like this in excel =MOD(MINUTE(C8:F16),15)>0
Thanks June7
this works great in a conditional format
What I need now is this - =SUMIF(G8:G16, "=10",M8:M16) converted into a string excel can cope with from Access VBA.
typed manually this works fine to sum only the rows that have 10 in the helper cell (G8:G16).
to get the last row number of the table i'm using Mid(last_cell, 4, 3)
so i'm guessing that it should look something like below but i can't get the syntax correct.
=SumIF(G8:G" & Mid(last_cell, 4, 3) & ",=10" & ",M8:M" & Mid(last_cell, 4, 3) & ")"