FSt1 -thanks again. Sorry the file isn't coming through. I've now
managed to input the formats+formula by cutting the s/s into two parts
and running the macro seperately on both. Maybe not best option but it
got me where I wanted to be. I think the s/s was just too big!
Big thanks.
Colwyn.


--
colwyn
------------------------------------------------------------------------
colwyn's Profile: http://www.thecodecage.com/forumz/member.php?userid=34
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=33071