Select the range of cells or click on the whole sheet button
(intersection of column and row headings) copy and then paste into the
blank worksheet. All of your hyperlinks should still work.


--
neopolitan


------------------------------------------------------------------------
neopolitan's Profile: http://www.excelforum.com/member.php...nfo&userid=611
View this thread: http://www.excelforum.com/showthread...hreadid=480844