The code runs great now thanks alot, you have saved me many hours... but
do you know how I can now adjust it a wee bit so it will name the new
sheets it generates with a list of vales in column B which correspond
with the names:

So like the first sheet will be called a cos b1 is a and the second
will be b cos b2 is b etc...


Yeah, i'm in Northern Ireland although i'm fairly sure my body clock is
running on american time ;)


--
Hru48
------------------------------------------------------------------------
Hru48's Profile: http://www.excelforum.com/member.php...o&userid=24895
View this thread: http://www.excelforum.com/showthread...hreadid=471460