+ Reply to Thread
Results 1 to 3 of 3

need repeating procedure to change row height

  1. #1
    Registered User
    Join Date
    03-12-2008
    Posts
    76

    need repeating procedure to change row height

    All,

    I just need a simple procedure which does the following:

    1) starts at Row 247
    2) changes the height of the row to 3
    3) loops 12 rows
    4) changes the height of row (247+12) to 3
    5) repeats the procedure until it has looped 50 times

    Thanks,

    Dave32

  2. #2
    Forum Moderator dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile

    Good afternoon Dave32

    Something like this should work OK for you :
    Please Login or Register  to view this content.
    HTH

    DominicB
    Please familiarise yourself with the rules before posting. You can find them here.

  3. #3
    Registered User
    Join Date
    03-12-2008
    Posts
    76

    need repeating procedure to change row height

    Thanks very much DominicB for your fast reply. The routine works perfectly!

    This is also useful for others.

    Dave32

+ 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. Editing a macro to change the row height in a merged cell
    By ordoff73 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-17-2008, 09:41 AM
  2. change height of single cell
    By Alex01 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-23-2007, 07:57 AM
  3. Adjust row height based on cell value
    By JoshuaSQ in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-24-2007, 02:40 PM
  4. Cannot change default Comment font type
    By Komatsu in forum Excel General
    Replies: 1
    Last Post: 12-23-2006, 11:23 AM
  5. convert unit change to percentile rank change
    By dujang in forum Excel General
    Replies: 1
    Last Post: 11-15-2006, 02:53 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