Visual basic excel application

Wrox Programmer Forums

		Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > Beginning VB 6
Visual basic excel application

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

November 23rd, 2005, 01:08 AM

momowu0701 momowu0701 is offline

momowu0701 is offline

Registered User

Join Date: Sep 2003

Posts: 8

Thanks: 0

Thanked 0 Times in 0 Posts

Default

Visual basic excel application

How can I auto resize a column to fit the length of a cell's content using the Excel Application object

Old

December 15th, 2005, 01:44 PM

jazzyJan

jazzyJan is offline

Registered User

Join Date: Dec 2005

Posts: 3

Thanks: 0

Thanked 0 Times in 0 Posts

Default

Hello momowu0701,

try this...

ActiveWorkbook.ActiveSheet.Columns.AutoFit

Succes

JazzyJan

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Visual Basic 6.0 - Application Error	miqbal	Pro VB 6	8	September 2nd, 2006 01:54 AM
Beginning Visual Basic 6 Application Development	kacheek	All Other Wrox Books	1	March 7th, 2004 05:30 AM
visual basic in excel help me	pakmaniac	Access VBA	2	January 2nd, 2004 10:55 AM
Manipulating Excel spreadsheet in Visual Basic	dreaming	VB How-To	8	November 20th, 2003 11:36 AM
Excel-Visual basic	kasimg	Excel VBA	1	August 9th, 2003 03:39 PM