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