#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Merge Cells

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

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

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 117
Default 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;

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatically merge mulitiple cells to one cells Edward Wang Excel Worksheet Functions 5 September 15th 09 07:56 PM
how do I merge cells into one then delete the original cells? LLR Excel Worksheet Functions 2 March 7th 08 10:59 PM
merge two cells Pam Coleman Excel Discussion (Misc queries) 6 April 22nd 06 02:39 PM
How do I merge cells in Excel, like just 2 cells to make one big . chattacat Excel Discussion (Misc queries) 2 January 19th 05 04:25 PM
Merge Cells R. Stevens Excel Discussion (Misc queries) 2 December 15th 04 09:30 PM


All times are GMT +1. The time now is 06:50 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"