Results 1 to 3 of 3

Fixed column width

Threaded View

  1. #1
    Registered User
    Join Date
    07-06-2009
    Location
    Netherlands, Amsterdam
    MS-Off Ver
    Excel 2003
    Posts
    9

    Fixed column width

    Hi,

    I'm trying to create a vb to get all columns on my sheet to have a fixed width.
    If I run my sub all columns go back to the set width. But I want the width to reset when the width is changed.

    Sub HeightWidth()
    
        Columns("A:C").ColumnWidth = 20
        Columns("D:D").ColumnWidth = 12
        Columns("E:F").ColumnWidth = 16
        Columns("G:G").ColumnWidth = 8
        Columns("H:H").ColumnWidth = 12
        Columns("I:M").ColumnWidth = 3
        Columns("N:N").ColumnWidth = 7
        Columns("O:O").ColumnWidth = 45
    
    End Sub
    Last edited by Terriz; 07-22-2009 at 05:18 AM. Reason: Won't fix

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1