| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Merge Macro | Excel Discussion (Misc queries) | |||
| Macro to Merge and Sum Rows | Excel Programming | |||
| macro to merge workbooks | Excel Programming | |||
| Need help with merge cells in a macro | Excel Programming | |||
| Macro to merge cells | Excel Programming | |||
![nshanmugaraj[_7_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
