Hi all.

Here is an example of how my sheet looks like

Name Class
a 1
b 1
c 1
d 2
h 2
j 2
k 3
l 3

and so on....


what i am trying to do is TO loop through the classes and print the students who are in the same class
in sheet prepaired with a range called rngStuNames

to be exact , i want the rngStuNames to be equal to the students in class 1 and print ,, then equal to class 2 and print ... abd so on ..

any help will be appreciated ,
thanks in advance.