Getting compile error 438 object doesn’t support this property or method

Hi Lewis,
Excellent! It's working fine.

The second part:

If I enter a roll number of a student in 'g7' Register sheet then the code should run.

Please suggest me a sheet code for it positively.

Thank you.