+ Reply to Thread
Results 1 to 5 of 5

Set height and width of cells

  1. #1
    Registered User
    Join Date
    08-31-2009
    Location
    washington, dc
    MS-Off Ver
    Excel 2003
    Posts
    55

    Set height and width of cells

    Hello,

    I am in desperate need of a macros that sets the heights and widths of columns and rows on a list of provided spreadsheets.

    On each of these sheets:

    MySheets = Array("FY09 Installation Support", "FY09 Install", "FY09 Purchase", _
    "FY09 CF Discretionary Grants", "FY09 CF LOI", "FY08 Purchase", _
    "FY08 Installation Support", "FY08 CF Discretionary Grants", _
    "FY07 Sup Install Support", "FY07 CF Install Non-LOI", "FY07 Sup Purchase", _
    "FY05 CF Carryover Install", "FY04 Recovery Funds", "FY05 Recovery Funds", _
    "FY08 Safety Carryover", "FY09 Safety", "FY09 Transport Canada")



    I need to set the height of all the rows to 18.00.
    I need to set the width of all of the columns to 12.00, except for columns A, C, and T, which need to be at a width of 28.00.



    any suggestions? Thank you in advance for your help.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    re: Set height and width of cells

    Hello copleyr,

    This macro will change the the row heights and columns widths of the specified worksheets.
    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Valued Forum Contributor
    Join Date
    10-15-2007
    Location
    Home
    MS-Off Ver
    Office 2010, W10
    Posts
    373

    re: Set height and width of cells

    Sorry, not happy with my solution.
    Last edited by lecxe; 08-31-2009 at 06:48 PM.

  4. #4
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    re: Set height and width of cells

    Hello,

    I dimensioned the variable Sht as a Worksheet. It should have been a Variant. Her eis the corrected code.
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    08-31-2009
    Location
    washington, dc
    MS-Off Ver
    Excel 2003
    Posts
    55

    re: Set height and width of cells

    Thank you so much!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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