+ Reply to Thread
Results 1 to 2 of 2

How to go about Setting spaces to Adjust column widths

  1. #1
    Registered User
    Join Date
    03-12-2016
    Location
    Harare Zimbabwe
    MS-Off Ver
    2013
    Posts
    82

    How to go about Setting spaces to Adjust column widths

    Good Day

    I have attachjed a worksheet I am working on. I eventually want to automate it but for now I am trying to get my layout correct.

    The File is called Help 24 Seven Members Invoice and Statment.xls

    1. Rows 1 - 10, coloumns A - H are the heading Block.
    2. Row 11 is a space.
    3. Row 12 is where we start the information that is inserted.
    4. From row 14 I would like to be able to adjust the coloumn widths, without adjusting the information in rows 1 - 10 and adjusting coloumn widths A- H in these rows.


    I am not sure if I have asked the correct question, I do hope my explanation does explain what I am trying to achieve.

    Many thanks

    Rodney
    Last edited by FDibbins; 08-18-2021 at 11:22 PM. Reason: removed file with personal info

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,936

    Re: How to go about Setting spaces to Adjust column widths

    1. Please dont include real/personal info in files here, it is a public forum and anyone can access your info (I have removed your file for you.

    2. What you want is not possible. You cannot adjust the column width for just a few rows and not for others in the same column/s
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. VB to: Open workbook, adjust column widths of select sheets, save, close
    By JPSIMMON in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-10-2017, 12:08 PM
  2. VBA to adjust Column Widths
    By JPSIMMON in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-24-2015, 06:02 PM
  3. [SOLVED] Setting column widths for multiple pages.
    By pawnraider in forum Excel General
    Replies: 3
    Last Post: 05-06-2014, 07:58 AM
  4. setting column widths
    By mwc0914 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-05-2007, 04:37 PM
  5. Automatically adjust column widths
    By stu_padassol in forum Excel General
    Replies: 1
    Last Post: 07-27-2006, 03:15 AM
  6. setting column widths in macro
    By davegb in forum Excel General
    Replies: 5
    Last Post: 01-26-2005, 03:06 PM
  7. Column widths to adjust automatically?
    By lambola in forum Excel General
    Replies: 1
    Last Post: 01-20-2005, 09:06 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