+ Reply to Thread
Results 1 to 2 of 2

Column Width Issue

  1. #1
    Registered User
    Join Date
    09-16-2008
    Location
    Syracuse, NY
    Posts
    5

    Column Width Issue

    I am trying to change the width of 4 columns in a spreadsheet that includes a pivot table. The problem is, as soon as I open up the drop downs on the pivot table, the column widths return back to their original size. Any ideas how to solve this issue would be greatly appreciated.

  2. #2
    Registered User
    Join Date
    04-18-2008
    Location
    Ipswich, England
    MS-Off Ver
    Office 2007, 2003, 2000, XP
    Posts
    17
    The easiest way would be to use a macro. Simply record a macro of the steps required to corect the column issue. The macro code will look something like this.

    Please Login or Register  to view this content.
    Even if you are new to VBA code, the code above is fairly obvious. The cursor is placed at cell B4, and the pivot table is refreshed. Column A is then selected and the width is set to 15. Then Column B, then C. Then Colums D,E & F are selected as D:F and set to width 14. The final line is simply moving the cursor (active cell) to where it is required, in this case the pivot table. It could be substituted for the first line of the code Range.....

+ 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. Excel 2007 : Column Width
    By Robin2 in forum Excel General
    Replies: 7
    Last Post: 09-04-2008, 05:54 AM
  2. Inserting a Column - Sometimes Works, Sometimes Not
    By teddybouch in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-11-2008, 06:52 PM
  3. enhancing Column A through Column B
    By julia81 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-14-2008, 11:23 PM
  4. Have top rows not comply to column width format?
    By Orlic in forum Excel General
    Replies: 1
    Last Post: 01-11-2008, 03:43 PM
  5. Autofit if characters in cell exceed column width
    By munkayboi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-10-2007, 03:45 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