Hi Gord,
I did essentially the same thing (without saving anything) and got the
expected results using Paul's code 'as is', saving for editing for the
sheetname containing the list.
I revised the code a bit but it doesn't do anything differently (I
simply removed unecessary vars).
Not sure why Brad can't get it working. The error will result when the
original sheetname is not '"Stud" & i'. I'm thinking he's trying to
rerun the code and one of the sheetnames has changed from a previous
attempt.
--
Garry
Free usenet access at
http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc