Unmerging macro

[DSLA]

Hi, i would like to unmerge all the cell that are in a certain excel sheet.

The button that Unmerges the sheet is in another sheet on the same excel file.

Anyone?

 

[Richard Schollar]

Hi

Sheets(YourSheetName).Cells.Unmerge

Richard

 

[DSLA]

It says that there is someking of error on the function.

This is the whole thing i have:

Private Sub CommandButton3_Click()
Sheets(Data1).Cells.UnMerge
End Sub

 

[Richard Schollar]

Hi

Looks like you may have to use:

Private Sub CommandButton3_Click() 
Sheets("Data1").Cells.UnMerge 
End Sub

Richard

 

[DSLA]

Thans, that worked. The scandinavian format is a bit different parently.
: )