Yes. Sorry I wasn't clear about that from the start. Copy and paste cells
containing hyperlinks to match destination formatting.
Thanks.

"p45cal" wrote:


Neither of these solutions (yours or the one below yours) transfers a
hyperlink in the cell properly but the formatting works. Any more
thots?Can I clarify; do you *just *want to copy hyperlinks (working) over?
This would simplify things a lot.


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=125922