+ Reply to Thread
Results 1 to 5 of 5

VBA to adjust row height,

  1. #1
    Forum Contributor
    Join Date
    11-17-2015
    Location
    India
    MS-Off Ver
    2013
    Posts
    365

    VBA to adjust row height,

    Hi,
    In attached data, I need VBA to perform below task.

    the code should run till the last row of serial number given in column A.

    1) in sheet Table1, Arrange a row width height to wrap text.
    2) in sheet Table1, But minimum width to be 22.2

    For Desired result please refer Sheet "Result".
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    11-17-2015
    Location
    India
    MS-Off Ver
    2013
    Posts
    365

    Re: VBA to adjust row height,

    can any one help me on this?

  3. #3
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: VBA to adjust row height,

    maybe so
    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    11-17-2015
    Location
    India
    MS-Off Ver
    2013
    Posts
    365

    Re: VBA to adjust row height,

    This will help in Wrap text. What if the data in one line I want to fixed row width to 22.2

    I need code to fix row height to minimum of 22.2 subject to maximum of wrap text height.

  5. #5
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,870

    Re: VBA to adjust row height,

    How about
    Please Login or Register  to view this content.

+ 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] Auto Adjust Row height
    By rajeshn_in in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-06-2017, 09:44 AM
  2. [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
  3. Replies: 0
    Last Post: 02-13-2016, 03:31 AM
  4. Auto Adjust Row Height
    By Gtrtim112 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-29-2015, 05:29 PM
  5. set row height AND atuo adjust?
    By tregrad in forum Excel General
    Replies: 1
    Last Post: 02-22-2012, 07:35 PM
  6. 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
  7. auto adjust row height
    By maacmaac in forum Excel General
    Replies: 2
    Last Post: 03-14-2007, 05:54 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