Ron de Bruin Wrote:
Hi Paul

Run this macro one time
http://www.rondebruin.nl/summary.htm


Ron

Thanks for this, it works ok if I use it as a macro within the
workbook, so have solved my current problem

I have since copied the macro to personal.xls so that I could use it
again with other workbooks, the macro runs ok but i cannot see the
Summary Sheet when I run it this way, when I run it again on a new
workbook I get a message saying the summary sheet already exists in
this workbook, but I cannot see it and it is not a hidden worksheet

Any help greatfully received

Paul


--
Paul Sheppard
------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=392061