Hi thanks for your help
but if the mark no , no of r1,r2 is different from time to time

for example
r1
r1
r2
r2
r2

next time is
r1
r1
r1
r1
r2

Then the macro recording cannot use.
then how to write the vba code ....maybe use if ...then...

Thanks
Tom