maybe that's not possible.

but i have another idea.

i want to select names in the listbox, which will then copy the entir
row of data beginning with that name. this procedure will copy all o
those rows and paste them into another sheet.

i can then execute another procedure that will calculate using this ne
data set.

is that possible

--
dream
-----------------------------------------------------------------------
dreamz's Profile: http://www.excelforum.com/member.php...fo&userid=2646
View this thread: http://www.excelforum.com/showthread.php?threadid=39729