ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Merge Cells (https://www.excelbanter.com/excel-worksheet-functions/261258-merge-cells.html)

CarlainCerebroMode

Merge Cells
 
I Just want to know how to merge via code two cells:
This doesn't work:

oSheet.Range['A34:A35'].merge:=true;


RonaldoOneNil

Merge Cells
 
Use Curly Brackets, double quotes and remove the true

oSheet.Range("A34:A35").Merge



"CarlainCerebroMode" wrote:

I Just want to know how to merge via code two cells:
This doesn't work:

oSheet.Range['A34:A35'].merge:=true;



All times are GMT +1. The time now is 03:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com