Macro error paste special with merged cells

[graeme]

I wrote a macro a while ago which works fine on my PowerBook G4 laptop
running OS 10.3 and Excel 2004. When I run it on my colleague's
PowerBook G3 laptop running OS 9.0.4 and Excel 2001 it falls over. Has
anyone had any experience of this:

The macro selects all the cells in a worksheet and does a paste special
to turn them all to values and this is where the os9 gets unstuck with
the following error message:

Run time error -1004 This operation requires the merged cells to be
identically sized.

I am pretty certain that the file which we are both operating on is the
same ie they both have merged cells but it runs ok on mine but not his.
Any ideas gratefully received.

 

[JE McGimpsey]

I wrote a macro a while ago which works fine on my PowerBook G4 laptop
running OS 10.3 and Excel 2004. When I run it on my colleague's
PowerBook G3 laptop running OS 9.0.4 and Excel 2001 it falls over. Has
anyone had any experience of this:

The macro selects all the cells in a worksheet and does a paste special
to turn them all to values and this is where the os9 gets unstuck with
the following error message:

Run time error -1004 This operation requires the merged cells to be
identically sized.

I am pretty certain that the file which we are both operating on is the
same ie they both have merged cells but it runs ok on mine but not his.
Any ideas gratefully received.

I'm not familiar with that, and I can't test XL01 right now, but an
alternative would be to use

With Worksheets("Sheet1").UsedRange
.Value = .Value
End With

instead. I know I've used that in XL01.

 

[graemeaustin]

Thanks. I'll try that and see if it makes any difference.

Cheers

Graeme