Wrox Programmer Forums
|
Beginning VB 6 For coders who are new to Visual Basic, working in VB version 6 (not .NET).
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Beginning VB 6 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 14th, 2007, 11:38 PM
Registered User
 
Join Date: Mar 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to anoopkpanicker
Default merging excel cells

hi

 i have a problem...i want to create an excelfile using vb code to display some details using html.first i am creating an html file using tables and the moved into excel sheet.i need to display the A1:H1 cells are merged how i can do this?
ANoop

 
Old March 26th, 2007, 05:11 PM
Authorized User
 
Join Date: Mar 2007
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to jgrant
Default

so you need to merge the cells? To merge the cells just copy paste the following code bit.

Dim myRange
Set myRange = Sheet1.Range("A1:H1")
myRange.Merge






Similar Threads
Thread Thread Starter Forum Replies Last Post
Selecting Cells In Flexgrid and Merging rfstuck Pro VB 6 0 April 10th, 2008 10:17 AM
Datagrid-Merging Cells p330418 ASP.NET 2.0 Professional 0 February 29th, 2008 12:06 AM
Merging cells in Datagrid p330418 ASP.NET 2.0 Basics 0 February 28th, 2008 11:21 PM
How to know cells in table is merging?? DorisTan VB How-To 0 January 13th, 2005 09:50 PM
merging excel cells in vb lip13 Beginning VB 6 1 December 30th, 2004 04:48 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.