Paste special and merged cells

[doggo]

Hi,

I have an interesting problem. I have a report that is dynamically created in a spreadsheet. There are several pages to the report with different layouts which has resulted in the use of merged cells in some rows (Now I know that this should be avoided at all costs but this is something I have worked on with another coder and it slipped through the loop)

So, Basically, I want to provide some export funrtionality (copy and past into new workbook). This is easy. However, What I really would like is only to display the values in the exported sheet to avoid linked cells etc.

My problem is that I can not do a paste special due to the merged cells. Any ideas of a way I can get around this?

 

[P Sitaram]

One way: Select the entire sheet and uncheck the Format|Merge Cells box before copying.

 

[doggo]

mmm, that will work in some respects but the problem that I would have here is that I would lose a lot of formatting on the report by unmerging the cells.