Merging and splitting cells or data

Hello Frédérique,.

(I'm an Excel application from (OfficeXP SP3/OWC10), Office 2007 SP2/OWC11 migration), and I have run the spreadsheet control on the performance in a major obstacle. The performance issue by merging of two cells (Range.merge statement).

I know that another control, but you have a workaround for the merge statement in the hope.

Here is an example of the code. I can send you the complete workbook.

Dim sRange1Start as string

Dim sRange1End as string

sRange1Start = "$ C$ 5"

"" sRange1End = "$ C$ 6"

sRange1End = "$ E$ 15"

Form1.Spreadsheet1.Range (.)Spreadsheet1.Range(sRange1Start).Address & ":" _

& .Spreadsheet1.Range(sRange1End).(Address).Merge

Kind regards

Saleem

View the original article here