macro to merge cell
 

hi

i need to merge cells on a button click

pls help


--
nshanmugaraj
------------------------------------------------------------------------
nshanmugaraj's Profile: http://www.excelforum.com/member.php...o&userid=31570
View this thread: http://www.excelforum.com/showthread...hreadid=518943

macro to merge cell
 

Range("A1:B1").MergeCells = True

'or... which allows you to reference cells by numerical value (say in a
loop)

Range(Cells(1, 1), Cells(1, 2)).MergeCells = True


Use MergeCells = False to reverse the settings

--
Cheers
Nigel



"nshanmugaraj"
wrote in message
news:nshanmugaraj.244u0b_1141454102.8507@excelforu m-nospam.com...

hi

i need to merge cells on a button click

pls help


--
nshanmugaraj
------------------------------------------------------------------------
nshanmugaraj's Profile:
http://www.excelforum.com/member.php...o&userid=31570
View this thread: http://www.excelforum.com/showthread...hreadid=518943

macro to merge cell
 

This may be useful to toggle the range between merge and unmerged using
control button on the sheet

Private Sub CommandButton1_Click()
If CommandButton1.Caption < "Unmerge" Then
CommandButton1.Caption = "Unmerge"
Range("A1:B1").MergeCells = True
Else
CommandButton1.Caption = "Merge"
Range("A1:B1").MergeCells = False
End If
End Sub

--
Cheers
Nigel



"nshanmugaraj"
wrote in message
news:nshanmugaraj.244u0b_1141454102.8507@excelforu m-nospam.com...

hi

i need to merge cells on a button click

pls help


--
nshanmugaraj
------------------------------------------------------------------------
nshanmugaraj's Profile:
http://www.excelforum.com/member.php...o&userid=31570
View this thread: http://www.excelforum.com/showthread...hreadid=518943