+ Reply to Thread
Results 1 to 3 of 3

Column Width Syntax

  1. #1
    Registered User
    Join Date
    01-24-2016
    Location
    UK
    MS-Off Ver
    2016
    Posts
    60

    Column Width Syntax

    hi folks,

    when I use this line

    Columns("F").ColumnWidth = 20 it works

    But when I try below it does not work



    Columns("F:F,L:L").ColumnWidth = 20

    what would be the correct syntax?

    thank you

    sl

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Column Width Syntax

    Hi,

    I would use Range rather than Columns:
    Please Login or Register  to view this content.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  3. #3
    Registered User
    Join Date
    01-24-2016
    Location
    UK
    MS-Off Ver
    2016
    Posts
    60

    Re: Column Width Syntax

    Thank you,
    perfect!
    sl

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Let dropdown list width expand beyond width of column so people can read answer choices?
    By xdrenched in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 11-15-2023, 02:05 AM
  2. VB Code to draw rectangle per data size
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-30-2016, 11:52 AM
  3. Reconciling units: Column width and image width
    By MarmaladeLover in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-13-2015, 03:03 PM
  4. Replies: 2
    Last Post: 07-30-2014, 11:13 AM
  5. [SOLVED] Merged Cell column width vs single cell column width
    By ratdogexcel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-28-2014, 12:23 AM
  6. Column Width vs. Text Width
    By jlt199 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-31-2013, 11:45 AM
  7. [SOLVED] Set Column Width Based On Total Width Of Other Columns
    By rayneraingoaway in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-28-2006, 06:10 PM

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