+ Reply to Thread
Results 1 to 4 of 4

ColumnWidth vs Column.Width

  1. #1
    Registered User
    Join Date
    11-02-2013
    Location
    Cebu, Philippines
    MS-Off Ver
    Excel 2007
    Posts
    21

    Question ColumnWidth vs Column.Width

    Hi,

    I've been search for the difference between ColumnWidth and Column.Width online but couldn't find answers. Please share if you have any ideas.

  2. #2
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: ColumnWidth vs Column.Width

    I think .columnwidth is in "characters" as a unit and .width is in "points"

    Edit: Had it the wrong way round
    Last edited by ragulduy; 11-22-2013 at 07:36 AM.

  3. #3
    Registered User
    Join Date
    11-02-2013
    Location
    Cebu, Philippines
    MS-Off Ver
    Excel 2007
    Posts
    21

    Re: ColumnWidth vs Column.Width

    sorry, i don't quite get it. .columnwidth similar to len?

  4. #4
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: ColumnWidth vs Column.Width

    no, characters is a measurement unit in excel, see:
    http://office.microsoft.com/en-gb/ex...001151724.aspx

+ 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. Column Width vs. Text Width
    By jlt199 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-31-2013, 11:45 AM
  2. Capture Activecell's ColumnWidth
    By srinivas1104 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-13-2011, 01:33 PM
  3. Cannot set ColumnWidth past column 148
    By MNTye in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-07-2006, 08:50 AM
  4. [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

Tags for this Thread

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