thanks to everyone for your responses...but all the options seem not t
work. Most return error messages. Maybe I am not explaining it right
am not sure, i am new to this visual basic stuff in excel. I guess wha
i wanted to do was make the number of rows in colum b equal the numbe
of rows in column d in 3 different sheets. Number of rows in column
has to equal b as well. I'm not sure if this helps or not but thank
again for responding

--
spear
-----------------------------------------------------------------------
speary's Profile: http://www.excelforum.com/member.php...fo&userid=2495
View this thread: http://www.excelforum.com/showthread.php?threadid=38487