+ Reply to Thread
Results 1 to 3 of 3

Row and Column width macro

  1. #1
    Registered User
    Join Date
    04-16-2011
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2007
    Posts
    16

    Row and Column width macro

    I was hoping someone could help with with a macro that makes all rows have a width of 18.75 and the C column have a width of 65. I plan to use this on a large number of sheets, so if it can preform this task to any arbitrary sheet (so i can tie it to a shortcut key) that would be awesome!
    Last edited by Luck; 05-11-2011 at 09:01 PM.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,365

    Re: Row and Column width macro

    Hi Luck,

    Rows have height so you asking to make all rows have witdth of 18.75 is confusing. We need to get you to learn how to turn on your macro recorder and do what you want above and you can learn to do this stuff by your self.

    1. Turn on the Macro Recorder
    2. Select all Cells and make rows heigth your number
    3. Select column C and make it your width.
    4. Turn off the macro recorder and look to what has been recorded.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    04-16-2011
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2007
    Posts
    16

    Re: Row and Column width macro

    By saying the width of a row I was speaking of the height, I saw it as trivial to mention the difference.

    Thanks for the input, I've always heard the macro recorder is kind of sketchy, but it works great for this!

+ 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