Pasting problems
 

Im making these large table that are usually created from other tables,
they all contain hyperlinks and general text.

Problem: When I copy and paste, the hyperlinks are being pasted into
other cells besides the one they are intended. I'll copy like 200
rows, 1 column and say there will be 10 empty cells, 4 linked cells, 10
empty, 4 linked.... and so on down the column.

when i go to paste in the new table, all cells are linked up, even if
there is no visible text.

How do i fix this, or better yet prevent it.

I've been using paste special, html paste and it still occurs time to
time.


--
mikeymike02135
------------------------------------------------------------------------
mikeymike02135's Profile: http://www.excelforum.com/member.php...o&userid=33243
View this thread: http://www.excelforum.com/showthread...hreadid=530684