+ Reply to Thread
Results 1 to 3 of 3

Insert column with width = sum of column E:P width

  1. #1
    Registered User
    Join Date
    02-11-2016
    Location
    Wisconsin
    MS-Off Ver
    07-360
    Posts
    53

    Insert column with width = sum of column E:P width

    I am trying to set up VBA to:
    1)Create a new Column.
    2)Have the new Column's width match the total width of Columns E through P.
    3)Work efficiently as the worksheet goes to P1285 before the new column is added.

    I am using the following Code:
    Please Login or Register  to view this content.
    I am not the most experienced with VBA but feel that this is close to what I am looking for. When I get to the column width portion, Excel locks up and requires task manager to shut it down (after waiting over 5 min).

    Any help would be greatly appreciated, Thanks!

  2. #2
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Insert column with width = sum of column E:P width

    Try
    Please Login or Register  to view this content.
    - Battle without fear gives no glory - Just try

  3. #3
    Registered User
    Join Date
    02-11-2016
    Location
    Wisconsin
    MS-Off Ver
    07-360
    Posts
    53

    Re: Insert column with width = sum of column E:P width

    That worked great, thank you!

+ 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. 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
  3. Replies: 2
    Last Post: 07-30-2014, 11:13 AM
  4. [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
  5. [SOLVED] Setting individual column width sizes for multi column listbox with VB2011 Mac not working
    By Nitefox in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 01-26-2014, 06:19 PM
  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

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