Probably, but you may want to try

Selecting the range
data|filter|autofilter

use the dropdown arrow to choose just the name you want to show.

mevetts wrote:

Hi,

I am creating a markbook (I'm a teacher) to hold all the results my
pupils achieve!

However, if it is necessary to speak to an individual pupil about their
grades I do not want to have all the other pupils marks on show.

Is there a way, perhaps using a macro, that will hide all other rows in
a given range except for the row that contains the active cell i.e the
row which the pupil in question occupies?

Many thanks,

Mark.

--
mevetts

------------------------------------------------------------------------
mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130
View this thread: http://www.excelforum.com/showthread...hreadid=495848

--

Dave Peterson