+ Reply to Thread
Results 1 to 2 of 2

Adjust row height(s) UNLESS row(s) are hidden (0).

  1. #1
    Registered User
    Join Date
    02-24-2021
    Location
    Guelph, Canada
    MS-Off Ver
    365
    Posts
    10

    Adjust row height(s) UNLESS row(s) are hidden (0).

    I use a macro to set up and adjust row heights, column widths, etc.......
    However, if I somehow mess up and of the set-ups, and I run my "page_layout" macro, it also "opens" up rows that are purposely hidden. Is there something that can be added to the code to prevent this.
    Something like: If Rows("3:114").RowHeight = 0, don't change them, else Rowheight = 15

    Current code:
    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor
    Join Date
    09-30-2018
    Location
    Vlaams Brabant Belgium
    MS-Off Ver
    365
    Posts
    456

    Re: Adjust row height(s) UNLESS row(s) are hidden (0).

    You where thinking in te right direction

    Please Login or Register  to view this content.
    Please be as complete as possible in your asking so it may save use all the time to rework the solution because you didn't give all the requirements. If you have a layout in mind please work it out first so we can adapt our solution to it. Thanks.
    If you have been helped, maybe you could click the *

+ 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. VBA to adjust row height,
    By saravanan1981 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-17-2019, 01:03 PM
  2. [SOLVED] Auto Adjust Row height
    By rajeshn_in in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-06-2017, 09:44 AM
  3. [SOLVED] How to adjust row height of row so tall the point to grab to adjust auto falls below
    By juntjoo in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 06-22-2016, 02:07 PM
  4. Replies: 0
    Last Post: 02-13-2016, 03:31 AM
  5. Auto Adjust Row Height
    By Gtrtim112 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-29-2015, 05:29 PM
  6. set row height AND atuo adjust?
    By tregrad in forum Excel General
    Replies: 1
    Last Post: 02-22-2012, 07:35 PM
  7. adjust lastrow In Col to a height of 7.5
    By erock24 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-20-2008, 01:25 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