Hi All,
I need help on the following VBA code.
I need to amend the formula below into a VBA code. I need to amend the 'O2:O662' section to show O2:O" & lastrow (used in previous VBA) or something that will work.
=CONCATENATE("Number of Cases"," ",COUNTIF(O2:O662,">=£0.01")," ","out of"," ",COUNTA(O2:O662))
Hope this makes sense?
Cheers
I need help on the following VBA code.
I need to amend the formula below into a VBA code. I need to amend the 'O2:O662' section to show O2:O" & lastrow (used in previous VBA) or something that will work.
=CONCATENATE("Number of Cases"," ",COUNTIF(O2:O662,">=£0.01")," ","out of"," ",COUNTA(O2:O662))
Hope this makes sense?
Cheers

Last edited: