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

Ask a Question

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.