copy paste

[kevin carter]

Hi
we have a worksheet that contains a lot of data.
there is a lot of merged cell
what i want to do is copy and paste the values of the cells from one
worksheet to another identical worksheet
the first worksheet contains a lot of links i need to break these links on
the second worksheet and display the text values of these cells

When i try to do this in a macro i am getting an error message telling me
cells not compatable
any ideas how i can resolve this ?

thanks in advance

kevin

 

[Frank Kabel]

Hi
probably your merged cells cause this problems. Your formats are not
identical for both sheets. Try to avoid the merge cells (or try if you
can copy/paste manually and record this action)