VBA For excel

Excel Discussion in 'Microsoft Office' started by Sam Wanner, Sep 12, 2017.

  1. Sam Wanner

    Sam Wanner

    Joined:
    Sep 12, 2017
    Likes Received:
    0
    I am working in VBA and have a report project that loops through all the facilities that we do business with. The project features pivot tables and I am using merge cells to create different row heights between the title page and the individual pivot table pages.
    Upon refresh of the pivot tables when encountering a new facility the row height resizes resulting in uneven spaces between entries in the pivot tables making for a very unattractive presentation,

    I have tried various work arounds including:
    1) unchecking autofit in pivot table options but leaving preserve cell formatting on update checked.
    2) locking with worksheet protection to programmatically prevent the row height from changing.
    Could not get to work because processing functions also became disabled.
    3) writing a line of gibberish in an adjacent unused column and wrapping it that someone suggested.
    Maybe I did not understand this solution but so far nothing has worked.

    Any ideas?
     
    Sam Wanner, Sep 12, 2017
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. vijayalakshmi.handi

    Excel Data validation for dependent list, VBA/EXCEL

    vijayalakshmi.handi, Oct 23, 2009, in forum: Microsoft Office
    Replies:
    0
    Views:
    1,425
    vijayalakshmi.handi
    Oct 23, 2009
  2. Tutankhamon

    Excel problem-VBA code for Excel (2007)

    Tutankhamon, Feb 6, 2010, in forum: Microsoft Office
    Replies:
    0
    Views:
    700
    Tutankhamon
    Feb 6, 2010
  3. playwithexcel

    Excel using vba code for solver in Excel

    playwithexcel, Dec 28, 2010, in forum: Microsoft Office
    Replies:
    0
    Views:
    2,048
    playwithexcel
    Dec 28, 2010
  4. KWL

    Excel Need VBA help for Excel Spreadsheet

    KWL, Apr 17, 2011, in forum: Microsoft Office
    Replies:
    1
    Views:
    1,603
    Stoneboysteve
    Apr 30, 2011
  5. jackb1117
    Replies:
    0
    Views:
    2,008
    jackb1117
    Sep 24, 2012
  6. smithb2

    Excel Excel VBA To Newer Excel Version

    smithb2, Aug 22, 2013, in forum: Microsoft Office
    Replies:
    1
    Views:
    1,226
    Flona2012
    Nov 3, 2013
  7. Panem Krupanandam

    Excel Formula Required for VBA code for excel

    Panem Krupanandam, Apr 15, 2016, in forum: Microsoft Office
    Replies:
    0
    Views:
    320
    Panem Krupanandam
    Apr 15, 2016
  8. srinivashydmummas

    Excel How to code in excel vba 2007 using absolute refernce for cells

    srinivashydmummas, Jul 19, 2016, in forum: Microsoft Office
    Replies:
    1
    Views:
    355
    bootneck02
    Jul 19, 2016
Loading...