Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default Visual basic excel application

Columns("C:C").Autofit

--

HTH

RP
(remove nothere from the email address if mailing direct)


"WilliamMomo" wrote in message
...
How can I auto resize a column to fit the length of a cell's content using
the Excel Application object



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,337
Default Visual basic excel application

is this what you wantWorksheets("Sheet1").Range("A1:E1").Columns.Au toFit--
Don Guillett
SalesAid Software

"WilliamMomo" wrote in message
...
How can I auto resize a column to fit the length of a cell's content using
the Excel Application object



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
change reference for 'visual basic for application' in VBA editor? yoyo2000 Excel Programming 6 September 29th 05 09:59 AM
How do I protect Visual Basic for Application Code Zagrijs Venter New Users to Excel 6 August 5th 05 09:24 PM
VBE( Visual Basic Application) phil[_4_] Excel Programming 1 July 7th 05 03:27 AM
How do I open an application and run a file using visual basic Cozy Excel Programming 0 March 13th 05 09:49 AM
Visual Basic run-time error when printing from web application... GWS Excel Programming 0 February 23rd 05 04:09 PM


All times are GMT +1. The time now is 10:21 PM.

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

About Us

"It's about Microsoft Excel"