Then you must have either more than one name in each cell, hidden rows or
merged cells, if the values are like


A B
1 name1
2 name2
3 name3
4


it will definitely take each cell separately when copied down

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


wrote in message
oups.com...
Hmm..now when im trying to run it, it uses two rows for the name of the
person. It's skipping a person every other row. Any ideas?