Hi Stewart,

I would use formulas but
that makes the workbook way too big - as I have to repeat
this for 18 subjects!

Use your formulas and then copy / paste special / values to convert the
formulas to values.

If you still want a macro solution, please give details of the data layout.

---
Regards,
Norman



"Stewart" wrote in message
...
I've got some results which I need to grade against some
benchmarks e.g.
A=90% and above
B=80% and above
C=70% and above

I've got 10000 pupils with varying results is there any
macro I can create to give each pupil a grade for their
result and put it on a worksheet (I would use formulas but
that makes the workbook way too big - as I have to repeat
this for 18 subjects!)

Thank you for any help you can give.

Stewart